unable view job history
-
Hi All,
One of a index rebuild job runs weekly once on Sunday. It runs fine and we get an email.
Somehow lately realized that when I try to view the job history , it is EMPTY . any specific reasons why the job history is being wiped out? Is there any settings for job history which is resulting in wiping out job history info?
Thanks,
Sam
-
Check to see if you have a filter set. Try hitting refresh. Go and query the history table directly.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
If you look at the SQL Server Agent properties - under the History page you will see these settings:
The first setting (Limit size of job history log) - if checked will perform an automatic purge of the job history log based on the settings. All it takes is one job that is scheduled to run every minute to cause a problem with being able to view past history. That one job would result in 60 files * 24 hours per day = 1,440 rows of history. The default limit is set to 1000 so the only history you would be able to find is anything that has run in less than the past day - or that one job.
The second check box is a one-time execution to purge out the job history based on how old the history.
You can try increasing the value, but if you do that then it will just fill up further with those jobs that run frequently. A better option is to schedule an agent job that purges the job history based on a date/time - and or frequency.
The better option is to schedule a job that manually purges the history using the procedure sp_purge_jobhistory. If you utilize maintenance plans you would also want to schedule a job to run sp_maintplan_delete_log. You can also create a maintenance plan that includes the maintenance history cleanup tasks - and set that to a specific time frame.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs -
Many thanks Grant and Jeff.
As Jeff pointed out the options , will try to change the values and see. Thanks Again.
-
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply