INF: Alerts and Tasks Can Occur When SQL Server Is Not Running

 Last reviewed: May 5, 1997
Article ID: Q152806

SUMMARY

The Alert and Task Engines in SQL Executive will work when SQL Server is not running. However, the Task Engine is limited to CmdExec tasks.

MORE INFORMATION

For example, you might want to create alerts that execute tasks on the following situations:

  1. SQL Server shut down normally.
2. SQL Server started. 3. A user database recovered successfully.

To create an alert on normal shutdown or starting of SQL Server, create the alert on the error number 17148 (Shutdown) or 17162 (Start) and do not filter by database name or error contains this string option.

To create an alert on a user database that has successfully recovered, create the alert on the error number 18109 and filter using the error contains this string option with the string "dbid x ckpt" where x is the dbid in the sysdatabases table of the master database for the database that you want to create an alert on. Note this alert will not work on the master, model or tempdb databases because their recovery messages are not written to the Windows NT Application log, which is what the Alert Engine of SQL Executive reads.

Additional query words: MSSQLServer SQLExective shutdown start
Version : 6.0 6.5
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 5, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.