SQLTeam.com | Weblogs | Forums

How to Track Which Job Step is Running

Hi experts,
For this agent job, I want to log the job step name that is currently running. This purpose of this is so I can simply read the table then email the recipients the name of the step that last completed.
This is NOT to determine whether the job completed successfully. I want to log each step name as it runs. Is there a way of retrieving the current job step name?.

It's in msdb.dbo.sysjobhistory

1 Like

Thanks, @ScottPletcher I have it working nicely now with your help.