notifications - SQL Server Agent for job failures without activating the Emails

Question

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

Answer 1

Waitting for answers