oraclespin.com
How to monitor jobs that are running on SQLServer through SQLServer Agent?
By calling msdb..sp_get_composite_job_info or msdb.dbo.sp_help_job one can find the current jobs running on SQLServer. Example: exec msdb..sp_get_composite_job_info @execution_status=1 Or exec msdb…