Microsoft KB Archive/152806

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

Article ID: 152806

Article Last Modified on 2/20/2002



This article was previously published under 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

Keywords: KB152806

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.