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

  • There is a problem in my servers as well that starts from 2008 data.

    I dont think any these jobs are still running which i can get from "Job Activity monitor".

    If you are trying to get job status try that data using SysJobHistory table with run_Status.

    You query have would be useful if the data would have available properly.

    Regards
    Durai Nagarajan