May 13, 2010 at 5:02 am
one of the job in our sql environment is failing frequently.so i need to take 1 monthy history of that job.Is it possible
May 13, 2010 at 6:48 am
Hello,
the quickest and simpliest way I'm thinking is to configure a notification in the job properties, to your e-mail adress, selecting the option 'when the job completes'.
May 13, 2010 at 6:49 am
Yes. Run EXEC sp_help_jobhistory @job_name = 'job_name' , @start_run_date = start_run_date . Start_run_date must be entered in the form YYYYMMDD (int).
May 13, 2010 at 6:51 am
You should verify the retention for job history, it could be that you cannot dispose of one month of history, sending the notification solves this problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply