May 7, 2008 at 3:13 am
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
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