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

  • OK has anyone solved this issue?

    Server and SQL Services were restarted 4 days ago.

    Here is the query I am running:

    select job.Name, job.job_ID, job.Originating_Server,

    activity.run_requested_Date, datediff(minute, activity.run_requested_Date, getdate()) as Elapsed, start_execution_date, run_requested_source

    from msdb.dbo.sysjobs_view job

    inner join msdb.dbo.sysjobactivity activity

    on (job.job_id = activity.job_id)

    where run_Requested_date is not null and stop_execution_date is null

    Results shows :

    run_requested_date Elapsed start_execution_date Run_requested_source

    2012-09-23 00:00:00.0005709182012-09-23 00:00:00.0001

    2013-03-20 01:15:00.0003145232013-03-20 01:15:00.0001

    2012-12-15 00:00:00.0004513982012-12-15 00:00:01.0001

    2012-09-15 00:15:00.0005824232012-09-15 00:15:00.0001

    2012-09-23 00:15:00.000570903NULL1

    2013-03-20 01:00:00.0003145382013-03-20 01:00:00.0001

    2013-10-22 00:00:00.0003558 2013-10-22 00:00:00.0001

    Can/how/should I delete these records?