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

  • dineshvishe (5/20/2013)


    reatart Sql Aget and see.

    Any problem,Let me know.

    please dont suggest to restart servers as it will affect production instead have to identify the root cause for it.

    From 2008 i have certain job like this status , so many time they have patched windows and sql and restarted the server.

    i think sql is not recording current job activity details properly.

    http://msdn.microsoft.com/en-IN/library/ms190484(v=sql.90).aspx

    Regards
    Durai Nagarajan