Find the Session ID of an executing SQL Agent job

On a busy production server I wanted to check when a job started running , I tried to look at the sysjob history table in the MSDB   However there are no entries for inflight jobs (meaning no entries for job that haven’t failed or pass) The sysjobschedules table from msdb will only show you…


Where is my SQL BPA(Best Practice Analyzer) for SQL 2014/2016/2017?

We recently built a SQL 2016 Server for a client and wanted to check if the best practices have been followed or not. Most of us have used the tool BPA (Best Practice Analyzer) to evaluate an instance. The Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions: Gathers information…


Configure Alerts for a Hung/Stuck SQL Agent Job step

SQL Server does a decent job alerting us of SQL Agent Job failures/ Success But, what if we  want to know if a job is hung, been running for a long time and has been stuck? When my customer approached me with the below problem I realized that the Job history table in the MSDB…

1