July 22, 2011 at 2:48 pm
I have a sql job that is supposed to run every 5 min. Starting from this week Monday, It's been running every 5 hour. I have to find out who change the schedule and when? Is there a system table that I can take a look? Or was there a bug reported regarding schedule disruption?
July 22, 2011 at 3:03 pm
Did you by chance have auditing turned on?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 3:12 pm
For grins - checked the default trace - it's not there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 22, 2011 at 3:34 pm
Wow. I didn't know I have a trace running in the server. Unfortunately, The trace file can go back up to Jul 19th. I have to find a event that happened during the last weekend. Any other way?
July 22, 2011 at 4:06 pm
Unless you had auditing enabled on the server - nope.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply