Email Notification trhu SQL SERVER using SMTP
-
Hi All, Hope everyone is doing great!!!. I am new to this group so any mistake in posting, i am sorry. I have a scenario, We have 5000+ scheduled jobs in the scheduler tool and the back end for that tool is sql server. We are manually monitring the job status and failuers which is taking huge efforts. For automating the monitoring process, we want to have Stored procedure which can be triggered when there is failure or status of jobs ran for every hour. I need help as how to have body of the message for reporting the job status and run times. I got the SP, but how to get the body of the message is what i am stuck with. Below is link from where i check the code. Please let me know if you need any information. Thanks a lot for your help in advance. Regards, Deepa http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/[^]
-
Hi All, Hope everyone is doing great!!!. I am new to this group so any mistake in posting, i am sorry. I have a scenario, We have 5000+ scheduled jobs in the scheduler tool and the back end for that tool is sql server. We are manually monitring the job status and failuers which is taking huge efforts. For automating the monitoring process, we want to have Stored procedure which can be triggered when there is failure or status of jobs ran for every hour. I need help as how to have body of the message for reporting the job status and run times. I got the SP, but how to get the body of the message is what i am stuck with. Below is link from where i check the code. Please let me know if you need any information. Thanks a lot for your help in advance. Regards, Deepa http://www.howtogeek.com/howto/database/sending-automated-job-email-notifications-in-sql-server-with-smtp/[^]
Member 10752578 wrote:
but how to get the body of the message is what i am stuck with
It is one of the parameters to the stored proc.
Member 10752578 wrote:
which can be triggered when there is failure
Might want to be careful with that. One failure is that it just didn't run. If it didn't run there is no way to generate a failure. Safer is to base results on missing successes.