May 5, 2011 at 7:14 am
My scheduled job failed and when I go to view history, there is no history, how can I find out why job failed? I checked sysjobhistory and I only see history for today, I am assuming that my server sat to view only todays data,how can I changed it?
Thank you
May 5, 2011 at 8:20 am
Right click on the SQL Server Agent and go into the Properties. Then the History tab. This is where you can increase how much info is saved before it is purged.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
May 5, 2011 at 8:38 am
Is there other way to view why job failed last night. we had it on 250 and I change it to 1000, should I worry about anything?
May 5, 2011 at 8:51 am
If the history was flushed, then you can not see the history.
In the future, you can also configure each step to write to a text file so you have an additional log, or raise the history limit much larger than 1000 and include step details in the history.
These are all settings that you can make now that will help you later. But your current history is gone, unless you already made a text file log before the job ran.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply