Home Forums SQL Server 2005 Administering sysJobActivity showing jobs from years ago that never ended RE: sysJobActivity showing jobs from years ago that never ended

  • durai nagarajan (5/22/2013)


    For example a job which runs daily and is in sysjobactivity as starting in 2010 but never finished will just show as normal for it's day to day routine in Job Activity Monitor. If it ran this morning and succeeded, then Job Activity Monitor say's it succeeded and the last run date was this morning. There is no mention of the 2010 instance of it in Job Activity Monitor.

    You can find the job run status , job start date , job start time and Duration with much more information here in sysjobhistory.

    Job Activity Monitor takes and shows the information from here. have you tried right click and check "View History" which will give more information.

    History table will have few records operated by settings set in agent properties , history.

    hope this will be useful.

    sysJobHistory does not show anything that is currently running, data is only stored here after the job step completes, which is why I'm looking at sysJobActivity:

    http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SYSJOBHISTORY_TSQL);k(SQL11.SWB.TSQLRESULTS.F1);k(SQL11.SWB.TSQLQUERY.F1);k(MISCELLANEOUSFILESPROJECT);k(DevLang-TSQL)&rd=true