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

我想产生一个审计报告， 前一天那些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, 但是只能看，不能声称报表。饿好像不知从 那下手，不知各位有什么建议。谢谢

所有跟帖： 

• Use Jobs to run Stored Procedures T-SQL and populate some tables -黄国人- ♂ (68 bytes) () 08/08/2011 postreply 15:21:16

• 回复：Use Jobs to run Stored Procedures T-SQL and populate some tab -回国找工作- ♂ (161 bytes) () 08/08/2011 postreply 15:30:02

• Auditing SQL Agent job creation and deletion -美国老土- ♂ (187 bytes) () 08/08/2011 postreply 16:17:36

• 谢谢老土，我做了这个audit,但是 -回国找工作- ♂ (10062 bytes) () 08/08/2011 postreply 17:14:00

• query sys.dm_audit_actions for every audit action that can be r -美国老土- ♂ (1112 bytes) () 08/08/2011 postreply 22:46:25

• 感觉应该对所有的JOBS -88647749- ♀ (164 bytes) () 08/09/2011 postreply 05:59:12

• 谢谢各位 -回国找工作- ♂ (103 bytes) () 08/09/2011 postreply 15:25:59