Post reply

Missing Job History - SQL 2005

  • May 20, 2009 at 8:09 am

    #132557

    Hi,

    I am experiencing an issue with missing job history and I am not sure what is going on. I do have SQL Server Agent properties for History configured using the default (Max job history = 1000, Min job history = 100). Furthermore there are jobs that are logged and others that are not which makes it harder for me to pin down the root cause of the problem.

    Also I've noticed that all maintenance plan jobs created using LiteSpeed v.5.0.2 have no history nor logging in msdb sysjob tables although these very same jobs are logged in LiteCentral tables.

    So in summaryl -- some jobs have history and logging in sysjob tables, others and all LiteSpeed maintenance jobs do not.

    Any help is greatly appreciated.

    Thanks

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • May 20, 2009 at 8:25 am

    #997626

    cos_ta393 (5/20/2009)

    Hi,

    I am experiencing an issue with missing job history and I am not sure what is going on. I do have SQL Server Agent properties for History configured using the default (Max job history = 1000, Min job history = 100). Furthermore there are jobs that are logged and others that are not which makes it harder for me to pin down the root cause of the problem.

    Also I've noticed that all maintenance plan jobs created using LiteSpeed v.5.0.2 have no history nor logging in msdb sysjob tables although these very same jobs are logged in LiteCentral tables.

    So in summaryl -- some jobs have history and logging in sysjob tables, others and all LiteSpeed maintenance jobs do not.

    Any help is greatly appreciated.

    Thanks

    Can't speak to litespeed except to say it probably logs its tasks to its own set of tables, perhaps in a separate database, maybe even in a separate instance using SQL Server Compact Edition.

    As for your jobs that don't have history, you may want to increase the value for Max Job History. With the setting of 1000, that means the total number of entries for job history for all jobs. You may want to increase that value to 10,000 or maybe higher depending on the number of jobs you have and how frequently they are running.

  • May 20, 2009 at 9:03 am

    #997673

    Thanks Lynn that did the trick.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • May 20, 2009 at 9:11 am

    #997686

    Glad to help.

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

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