view job history got cleared automatically!!

  • Hello Friends!!!

    We have scheduled jobs running at certain interval and we need to check it frequently history of that jobs. We are doing this by watching it in

    Sql Server Agent>jobs>then by right click the job we get menu where we finds job view job history. Till in afternoon that was working fine but in evening what we found is that all job history got cleared automatically for all job!

    Can anybody have any idea @ this? How job history got cleared automatically?

    Please help me out!!

    T.I.A

    Shashank

     


    Regards,

    Papillon

  • They do not disappear by themselves.

    They have either been deleted through someone clicking on Clear All button

    Or, I there is a setting at sql server agent level where you can define maximum log files allowed.

    Right click on sql server agent, Properties, job system tab and maximum job history rows per row. Perhaps a DBA set this to 0.


    ------------------------------
    The Users are always right - when I'm not wrong!

  • It's a SQL Server Agent setting.  Right-click on the Agent in EM, select properties, Job System tab.  You can choose whether or not to limit the job history log size and what the limit will be.

    Greg

    Greg

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

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