SQL Server Agent Tables (Transact-SQL)

In This Section

• syssubsystems
  Contains one row for each alert.

• syscategories
  Contains the categories used by SQL Server Management Studio to organize jobs, alerts, and operators.

• sysdownloadlist
  Holds the queue of download instructions for all target servers.

• sysjobactivity
  Contains information about current SQL Server Agent job activity and status.

• sysjobhistory
  Contains information about the execution of scheduled jobs by SQL Server Agent.

• sysjobs
  Stores the information for each scheduled job to be executed by SQL Server Agent.

• sysjobschedules
  Contains schedule information for jobs to be executed by SQL Server Agent

• sysjobservers
  Stores the association or relationship of a particular job with one or more target servers.

• sysjobsteps
  Contains the information for each step in a job to be executed by SQL Server Agent.

• sysjobstepslogs
  Contains information about job step logs.

• sysnotifications
  Contains one row for each notification.

• sysoperators
  Contains one row for each SQL Server Agent operator.

• systargetservergroupmembers
  Records which target servers are currently enlisted in this multiserver group.

• systargetservergroups
  Records which target server groups are currently enlisted in this multiserver environment.

• systargetservers
  Records which target servers are currently enlisted in this multiserver operation domain.

• systaskids
  Contains a mapping of tasks created in earlier versions of SQL Server to Management Studio jobs in the current version.

• sysproxies
  Contains information about SQL Server Agent proxy accounts.

• sysproxylogin
  Records which SQL Server logins are associated with each SQL Server Agent proxy account.

• sysproxysubsystem
  Records which SQL Server Agent subsystem is used by each proxy account.

• sysschedules
  Contains information about SQL Server Agent job schedules.

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

• syssubsystems
  Contains information about all available SQL Server Agent proxy subsystems.