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
Thanks, @ScottPletcher I have it working nicely now with your help.