Post reply

sql server agent Jobs

  • May 7, 2008 at 3:13 am

    #125180

    Dear all,

    I created two jobs let it be Jobdaily, jobevery

    where Jobdaily scheduled as once in a day

    and jobevery scheduled as for every ten minutes.

    but while view the jobs history

    i got the result set for jobevery (scheduled for every ten minutes)

    and no result for Jobdaily .

    what's the reason and how to rectify it ?

    Thanks and Regards,

    N.Prabhakaran

  • May 7, 2008 at 5:12 am

    #811675

    The number of jobhistory records which are kept in the masb is limited. If I remember right the default is 1000 rows. It looks like your every10min job creates so much historyrows that the daily job rows are already flushed out by the time you check.

    You can increase the number of rows kept in the SQL Agent properties. In SSMS richt click on SQL Agent and open the properties. Under History you can increase the default settings.

    But keep in mind that increasing the history threshold will also increase the size of your msdb.

    [font="Verdana"]Markus Bohse[/font]

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

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