In order to get or check currently running Jobs in SQL Server, run below script : SELECT J.name as Running_Jobs, JA.Start_execution_date...

In order to get or find last run status of scheduled Jobs, run below script : USE msdb GO SELECT DISTINCT SJ.Name AS JobName,...

In order to get or find SQL Server details, run below script : CREATE TABLE #ServerDetails(ID int, Name sysname, Internal_Value int,...