System Tables–SQL Executive Tables

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.