Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
This section describes the system tables that store information SQL Server Agent uses. All tables are in the dbo schema in the msdb database.
Tables
| Table | Description |
|---|---|
| dbo.sysalerts | Contains one row for each alert. |
| dbo.syscategories | Contains the categories that SQL Server Management Studio uses to organize jobs, alerts, and operators. |
| dbo.sysdownloadlist | Holds the queue of download instructions for all target servers. |
| dbo.sysjobactivity | Contains information about current SQL Server Agent job activity and status. |
| dbo.sysjobhistory | Contains information about scheduled jobs that SQL Server Agent runs. |
| dbo.sysjobs | Stores information for each scheduled job that SQL Server Agent executes. |
| dbo.sysjobschedules | Contains schedule information for jobs that SQL Server Agent executes. |
| dbo.sysjobservers | Stores the association or relationship of a particular job with one or more target servers. |
| dbo.sysjobsteps | Contains information for each step in a job that SQL Server Agent executes. |
| dbo.sysjobstepslogs | Contains information about job step logs. |
| dbo.sysnotifications | Contains one row for each notification. |
| dbo.sysoperators | Contains one row for each SQL Server Agent operator. |
| dbo.sysproxies | Contains information about SQL Server Agent proxy accounts. |
| dbo.sysproxylogin | Maps SQL Server logins to SQL Server Agent proxy accounts. |
| dbo.sysproxysubsystem | Records which SQL Server Agent subsystem each proxy account uses. |
| dbo.sysschedules | Contains information about SQL Server Agent job schedules. |
| dbo.syssessions | Contains the SQL Server Agent start date for each SQL Server Agent session. SQL Server Agent creates a session each time the service starts. |
| dbo.syssubsystems | Contains information about all available SQL Server Agent proxy subsystems. |
| dbo.systargetservergroupmembers | Records target servers enlisted in this multiserver group. |
| dbo.systargetservergroups | Records target server groups enlisted in this multiserver environment. |
| dbo.systargetservers | Records target servers enlisted in this multiserver operation domain. |
| dbo.systaskids | Contains a mapping of tasks created in earlier versions of SQL Server to Management Studio jobs in the current version. |