SQL Agent Jobs，如何记录 [英] SQL Agent Jobs, how to document

问题描述

我想以一种日历结尾，该日历显示不同的计划作业及其步骤（执行的确切命令）。但是我很难找到所有数据。所以我的问题有两个方面：

I want to end up with a sort of Calendar that shows the different scheduled jobs and their steps (the exact command executed). But I"m having a hard time finding all the data. So my question is two-fold:

1）是否有人知道软件（最好是开源或免费的） ）可以以电子表格或其他易于操作的格式从sql server 2000中获取此数据？

1) Does anyone know of a software (preferably open source or free) that can get this data from sql server 2000 in a spreadsheet or other easy to manipulate format?

2）有人可以帮助我处理需要获取的查询吗？

2) Can anyone help me with the queries I'd need to get this data. How are SQL Agent Jobs organized in the database?

欢迎对此问题提供任何指导。

Any guidance on this issue would be welcome.

推荐答案

有关作业的信息存储在服务器上的MSDB数据库中。

The information regarding jobs is stored in the MSDB database on your server.

MSDB数据库中的表您会很感兴趣（名称是自

Tables in the MSDB database will be of interest to you (names are self-explanatory)

• sysjobs


• sysjobsteps

日程表存储在这里

• sysjobschedules

您可以执行此处的历史记录

You can get execution history here

• sysjobhistory

有几个内置过程可为您提供帮助详细信息：

There are several built in procedures to help you with the details:

• sp_help_job


• sp_help_jobhistory


• sp_help_jobschedule

这篇关于SQL Agent Jobs，如何记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！