sql 查询超时已过期_监视来自SQL Server代理作业的查询超时过期消息

sql 查询超时已过期

SQL Server provides you with a good solution to automate a lot of your administrative tasks using the SQL Server Agent jobs. These jobs are handled from the operating system side by a Windows service that is responsible for executing these jobs and feeding the SQL Server systems tables with the metadata about these jobs. The system database that is used by the SQL Server Agent for the job management called the msdb database. All information related to the job steps, schedules and the history can be found in the msdb database tables. The msdb system database is also responsible for the SQL Server Mail, Service Broker, SQL Server Maintenance Plans and the databases backup history.

SQL Server为您提供了一个很好的解决方案，可以使用SQL Server代理作业自动执行许多管理任务。 这些作业由Windows服务从操作系统端处理，该Windows服务负责执行这些作业并向SQL Server系统表提供有关这些作业的元数据。 SQL Server代理用于作业管理的系统数据库称为msdb数据库。 与作业步骤，时间表和历史记录有关的所有信息都可以在msdb数据库表中找到。 msdb系统数据库还负责SQL Server邮件，Service Broker，SQL Server维护计划和数据库备份历史记录。

The msdb database tables that store information about the SQL Server Agent jobs are: the dbo.sysjobactivity which contains information about the SQL Server Agent job activates, the dbo.sysjobhistory table that keeps information about the execution history for the agent jobs , the dbo.sysjobs table that contains information about all the SQL Agent jobs, the dbo.sysjobschedules table that stores information about the schedules for all SQL Agent job, the dbo.sysjobservers table that contains the association of the SQL Agent jobs with the target servers, the dbo.sysjobsteps table that stores information about the SQL Agent jobs steps and the dbo.sysjobstepslogs table that stores logs about the SQL Agent jobs steps.

存储有关SQL Server代理作业信息的msdb数据库表包括：dbo.sysjobactivity，其中包含有关SQL Server Agent作业已激活的信息； dbo.sysjobhistory表，其中包含有关代理作业的执行历史的信息； dbo。 sysjobs表（包含有关所有SQL Agent作业的信息）， dbo.sy