Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

SQL Server Agent Tables (Transact-SQL)

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.