Frequently we may want to know the list of jobs which are currently running on a server.
From the msdb..sysjobhistory we can get the details of the jobs which are completed either successfully or the jobs which are failed/cancelled.
To know the list of jobs currently running execute the below query:
exec msdb..sp_help_job @execution_status = 1
