View Job History

  • In one of my JOB It's overwriting the Job History instead of appending to the previous list. All other jobs showing the history. I couldn't find where I can set this option to append each execution details.

    Jagan

  • I got this set to Maximum Job History Rows per Job increased in SQL Server Agent Properties.

    jagan

  • I'm not sure about this but I think that "sp_add_job" - @delete_level = 0 should do it....check your script and see if the @delete_level is set to 1 for the job where it's overwriting...!!!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply