Good day,
I have an automation sql agent job that triggers another 2 jobs on certain steps, i had an incident where the server was restarted and i got no fialure notifications
i have created another job to check services restarted
the auomtion job has notification for onfailure etc, i would like to go one step further.
for example if second job did not start @4am send notification etc so that i know there's other issues (job hanging, failure didnt trigger etc)
i have a step that executes a send email but i need someting that can check status of steps within jobs or job not completed by x time sonething has failed
Any ideas please?
regards