SQL Server Agent Tables (Transact-SQL)

  • Article

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.

In This Section

  • 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.