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

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.