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?