Is there any SQL query where if any job steps fail it need to be notified to user, along with job execution for only failure notifications.
For example:
If we have Test job and it has 6 steps, if 4th step failed and rest all succeeded in this case it needs to notify user with job name and step name and failure for the particular step reason.
Thanks
I have tried few t-sql queries which have limitations that are, to send on daily basis or sending all the failure job's steps at a time. But my requirement is when job is executing if particular step of that job is failed immediately it need to notify the user.