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:
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 : |
Last Reviewed: March 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |