SQL Executive handles event scheduling and alert management for any SQL Server process, such as replication. All scheduling information is stored within the msdb database.
The msdb database uses the following tables for scheduling purposes:
Table | Description |
---|---|
sysalerts | Contains one row for each alert. |
syshistory | Contains one row for each task that has occurred. |
sysnotifications | Contains one row for each notification. |
sysoperators | Contains one row for each operator. |
systasks | Contains one row for every scheduled task. |