How to Find out which SQL Server Agent Jobs are Running at the moment - SQL Server DBA Tutorial

In this video you will learn how to find out which SQL Server Agent Jobs are running at he moment using different methods.

1- Using SQL Server Object Explorer
2- Using Job Activity Monitor
3- Using T-SQL Script
Video also walks you through some important SQL Server Agent Jobs related store procedure that can come handy when you need to quickly find out information about your SQL server Agent Jobs.


Script to Find out Currently Running SQL Server Agent Jobs on SQL Server Instance


SELECT
    J.Name, J.job_ID
 ,A.run_requested_Date
    
FROM
    msdb.dbo.sysjobs J 
        INNER JOIN msdb.dbo.sysjobactivity A
        ON (j.job_id = A.job_id)
WHERE
    run_Requested_date is not null 
    AND stop_execution_date is nul




Find Currently Running Jobs on SQL Server by SQL Server Agent - SQL Server DBA Tutorial

No comments:

Post a Comment