SQL Server Agent Tables (Transact-SQL)
The topics in this section describe the system tables that store information used by SQL Server Agent. All tables are in the dbo schema in the msdb database.
- dbo.sysalerts
-
Contains one row for each alert.
- dbo.syscategories
-
Contains the categories used by SQL Server Management Studio 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 the execution of scheduled jobs by SQL Server Agent.
- dbo.sysjobs
-
Stores the information for each scheduled job to be executed by SQL Server Agent.
- dbo.sysjobschedules
-
Contains schedule information for jobs to be executed by SQL Server Agent
- dbo.sysjobservers
-
Stores the association or relationship of a particular job with one or more target servers.
- dbo.sysjobsteps
-
Contains the information for each step in a job to be executed by SQL Server Agent.
- 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
-
Records which SQL Server logins are associated with each SQL Server Agent proxy account.
- dbo.sysproxysubsystem
-
Records which SQL Server Agent subsystem is used by each proxy account.
- 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. A session is created each time the SQL Server Agent service starts.
- dbo.syssubsystems
-
Contains information about all available SQL Server Agent proxy subsystems.
- dbo.systargetservergroupmembers
-
Records which target servers are currently enlisted in this multiserver group.
- dbo.systargetservergroups
-
Records which target server groups are currently enlisted in this multiserver environment.
- dbo.systargetservers
-
Records which target servers are currently 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.
