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

  • Sean Pearce (5/23/2013)


    Ross.M (5/14/2013)


    So my questions are:

    (1) What might have caused this?

    (2) Is it safe to just do an UPDATE on these records and change the stop_execution_date to something like '1900-01-01'

    (3) Are there any better ways to tidy this up?

    You can tidy this up by scripting the job as drop and create.

    Hi Sean, not sure I know what you mean?