question

ebzm avatar image
ebzm asked

Job schedule change

Can someone help me out in figuring out who changed the maintenance plan schedule? Ten days ago this job started running every 20min and need to know who set it up to prevent it from happening again. The log files only go 1 day. Please help.
maintenance-plansmaintenance
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Tim avatar image
Tim answered
Are you saying the scheduled job history only goes back 1 day or your SQL Server log only goes back 1 day. Hopefully you are only talking about the scheduled job. Review your SQL Server log and you should see the change in there. You might also take a look at who all has the rights to make such a change and approach them individually. The number of people that can make this type of change on a production box should be FEW.
8 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ebzm avatar image ebzm commented ·
It is too big to open the sql server log file. Any suggestion please?
0 Likes 0 ·
Tim avatar image Tim commented ·
Are you getting an error message trying to open the SQL Server log file? I haven't ever had an issue opening the file on any of my servers. On a couple of them it might take a few seconds to open but they have never been so large that I could access them. How are trying to access the log?
0 Likes 0 ·
ebzm avatar image ebzm commented ·
tlog was out of control b/c of san latency issues. That is the reason why it got too big to open it up.
0 Likes 0 ·
ebzm avatar image ebzm commented ·
Do you know for sure the sql server log will tell me when the maintenance plan schedule was changed by whom and so forth?
0 Likes 0 ·
Tim avatar image Tim commented ·
Only if you were auditing for that type of event. As @grant fritchey pointed out this information would show up in the default trace. I have verified that is true. What version of SQL Server are you running? You set up auditing to audit SQL Server Agent job changes.
0 Likes 0 ·
Show more comments
Grant Fritchey avatar image
Grant Fritchey answered
I think those changes might be available in the default trace, but I'm not sure about that. It's worth checking. Here's some info on the [default trace.][1] [1]: http://msdn.microsoft.com/en-us/library/ms175513.aspx
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ebzm avatar image ebzm commented ·
They are gone. I can only go back to one more day.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
The trace rolls over. Check the folder defined in the link I provided. It's not the logs, it's the default trace. It's different.
0 Likes 0 ·
ebzm avatar image ebzm commented ·
yes, the default trace 'log_1.trc' doesn't go back more than one day.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
And what about log_2.trc it rolls over every 20mb by default. You may not be able to go back 10 days, but you can try.
0 Likes 0 ·
ebzm avatar image ebzm commented ·
Thanks for your response. Unfortunately, the logs have been recycled.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.