请教 SQL 及老土高手,请给些建议

来源: 2011-08-08 15:02:30 [博客] [旧帖] [给我悄悄话] 本文已被阅读:

我想产生一个审计报告, 前一天那些SQL Agent job 被修改, 创建那些新的job, 那些job被删除

要求如下:A daily audit report listing job additions, deletes and modifies that
    occurred in the previous day.
-   The report must cover the changes, when available, to the job definitions,
    steps and schedules.
-   The report should list:
    - job name
    - change action (add,del,mod)
    - change scope:  job, job step, job schedule
    - change date
    - count of total # of jobs and # of jobs that did not change.
我上一开始想用SQl 2008 Audit , audit 结果到application log, 但是只能看,不能声称报表。饿好像不知从 那下手,不知各位有什么建议。谢谢