How to Track Which Job Step is Running

SQL Server Administration
1

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?.
Thanks

2

It's in msdb.dbo.sysjobhistory

1 Like
4

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