Log history for SQL Job( Agent job)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Log history for SQL Job( Agent job)

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-09-05 : 00:19:44

Hi All,

One of our production daily running Job has been disabled by someone in the SQL job agent.

How to track who was disabled this job in SQL server 2005 enterprise edition SP3 on Windows server 2003 SP2

Thanks,
Gangadhara MS
SQL Developer and DBA

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-09-07 : 11:25:55

For this we have placed a filtered trace based on filter "sp_update_job", enable = 0 indicates shows, job is disabled.

SQL Server: Script to Start and Stop a New Trace without Using Profiler GUI

http://connectsql.blogspot.com/2012/08/sql-server-script-to-start-and-stop-new.html?utm_source=BP_recent
--------------------------
http://connectsql.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources