I have a scheduled SQL Agent job which runs over the night every day.
I want to set up a email notification for that job but I also have some constraints for that particular server.
Constraints: I can not activate Emails alter from Job properties due to some security issue. and I also can not create @profile_name to use sp_send_dbmail for the same security reason.
What else option I can consider to send notification of that job when any step failed.
question from:https://stackoverflow.com/questions/66065062/sql-server-agent-for-job-failures-without-activating-the-emails
