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

  • homebrew01 (5/21/2013)


    I also have old "orphaned" active jobs. I ran across it a few weeks ago when creating a report to alert me about long running jobs and failed job steps. I just filter them out of my query and ignore them.

    Are you sure it is "orphaned" active jobs, because i have a job showing in this query which is on 2008 but executing it fine now.

    How a orphaned job can run now wihtout any issues. i hope these are not properly maintained session.

    Regards
    Durai Nagarajan