Post reply

job log history only is holding 1 item for each job

  • February 19, 2013 at 9:17 pm

    #270641

    Hi,

    I am on sql 2008 r2 enterprise x64.

    For some reason each job is holding only 1 entry in the job log. The agent settings are default

    limit job history log is set to on

    maximum job log history size (rows) is 1000

    number of rows per job is 100

    remove agent history is set to off

    What is the issue here?

  • February 19, 2013 at 9:26 pm

    #1589426

    Jordan,

    How many rows you have in sysjobhistory?

    select * from msdb.dbo.sysjobhistory

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 19, 2013 at 9:33 pm

    #1589427

    1023 rows

  • February 19, 2013 at 10:10 pm

    #1589431

    Even though you have give 100 rows per job, maximum number of (total) rows(1000) is reaching frequently.

    You can increase this to say 5000 and see whether it is enough for your enviroment

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 19, 2013 at 10:54 pm

    #1589433

    thanks mate - I'll try it out!

Viewing 5 posts - 1 through 4 (of 4 total)

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