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
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