| title | SQL Server Agent Tables (Transact-SQL) | ||
|---|---|---|---|
| description | SQL Server Agent Tables (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 03/14/2017 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
The topics in this section describe the system tables that store information used by [!INCLUDEssNoVersion] 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 [!INCLUDEssManStudioFull] to organize jobs, alerts, and operators.
dbo.sysdownloadlist
Holds the queue of download instructions for all target servers.
dbo.sysjobactivity
Contains information about current [!INCLUDEssNoVersion] Agent job activity and status.
dbo.sysjobhistory
Contains information about the execution of scheduled jobs by [!INCLUDEssNoVersion] Agent.
dbo.sysjobs
Stores the information for each scheduled job to be executed by [!INCLUDEssNoVersion] Agent.
dbo.sysjobschedules
Contains schedule information for jobs to be executed by [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Agent.
dbo.sysjobstepslogs
Contains information about job step logs.
dbo.sysnotifications
Contains one row for each notification.
dbo.sysoperators
Contains one row for each [!INCLUDEssNoVersion] Agent operator.
dbo.sysproxies
Contains information about [!INCLUDEssNoVersion] Agent proxy accounts.
dbo.sysproxylogin
Records which [!INCLUDEssNoVersion] logins are associated with each [!INCLUDEssNoVersion] Agent proxy account.
dbo.sysproxysubsystem
Records which [!INCLUDEssNoVersion] Agent subsystem is used by each proxy account.
dbo.sysschedules
Contains information about [!INCLUDEssNoVersion] Agent job schedules.
dbo.syssessions
Contains the [!INCLUDEssNoVersion] Agent start date for each [!INCLUDEssNoVersion] Agent session. A session is created each time the [!INCLUDEssNoVersion] Agent service starts.
dbo.syssubsystems
Contains information about all available [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] to [!INCLUDEssManStudio] jobs in the current version.