Udostępnij za pośrednictwem

SQL Server Agent Tables (Transact-SQL)

  • Artykuł

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.

W tej sekcji

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