Delen via


SQL Server Agent Tables (Transact-SQL)

The topics in this section describe the system tables that store information used by SQL Server Agent.

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.