SQL Server Agent Tables
The topics in this section describe the system tables that store information used by SQL Server Agent.
In This Section
| Topic | Description |
|---|---|
Contains one row for each alert. |
|
Contains the categories used by SQL Server Management Studio to organize jobs, alerts, and operators. |
|
Holds the queue of download instructions for all target servers. |
|
Contains information about current SQL Server Agent job activity and status. |
|
Contains information about the execution of scheduled jobs by SQL Server Agent. |
|
Stores the information for each scheduled job to be executed by SQL Server Agent. |
|
Contains schedule information for jobs to be executed by SQL Server Agent |
|
Stores the association or relationship of a particular job with one or more target servers. |
|
Contains the information for each step in a job to be executed by SQL Server Agent. |
|
Contains information about job step logs. |
|
Contains one row for each notification. |
|
Contains one row for each SQL Server Agent operator. |
|
Records which target servers are currently enlisted in this multiserver group. |
|
Records which target server groups are currently enlisted in this multiserver environment. |
|
Records which target servers are currently enlisted in this multiserver operation domain. |
|
Contains a mapping of tasks created in earlier versions of SQL Server to Microsoft SQL Server 2005 Management Studio jobs in the current version. |
|
Contains information about SQL Server Agent proxy accounts. |
|
Records which SQL Server logins are associated with each SQL Server Agent proxy account. |
|
Records which SQL Server Agent subsystem is used by each proxy account. |
|
Contains information about SQL Server Agent job schedules. |
|
Contains the SQL Server Agent start date for each SQL Server Agent session. A session is created each time the SQL Server Agent service starts. |
|
Contains information about all available SQL Server Agent proxy subsystems. |