SELECT
j.name AS 'Nombre del Job',
ja.start_execution_date AS 'Inicio a las:',
Datediff(ss, ja.start_execution_date, Getdate()) AS 'Ha corrido por: (Segundos)'
FROM msdb.dbo.sysjobactivity ja
INNER JOIN msdb.dbo.sysjobs J
ON j.job_id = ja.job_id
WHERE job_history_id IS NULL
AND ja.start_execution_date IS NOT NULL
ORDER BY start_execution_date
No hay comentarios:
Publicar un comentario