lptech (11/26/2013)
Start with the sysjobactivity table, and you should be able to come up with something that fits your needs.
I don't have a 2000 server to test agaisnt, but assuming the table is still the same, i *think* this will give you teh results you are looking for?
SELECT
DATEDIFF(minute,start_execution_date,getdate()) AS ElapsedMinutes,
*
FROM msdb.dbo.sysjobactivity
WHERE start_execution_date IS NOT NULL
AND stop_execution_date IS NULL
Lowell