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

  • Ross.M (5/23/2013)


    Sean Pearce (5/23/2013)

    Right click your job in SSMS

    Script Job as -->

    DROP And CREATE To -->

    New Query Editor Window

    Execute the script.

    Wouldn't this remove all of the job's history?

    Yes, it would by default. You can specify @delete_history = 0 when deleting the job but the newly created job would have a different job_id. In an earlier post you specified

    I'm looking for jobs that are currently running

    which doesn't need any history.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]