請教 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