How to send email to multiple email accounts from SQL Server Agent Job if fails_sp_send_dbmailEXEC _send_dbmail -Your profile name = 'Techbrothers', -Your multiple recipients = 'Job Failed Please check ASAP', = 'Job Failed on Production System'Script 2: -How to send email to multiple email accounts from SQL Server Agent Job if fails_addOperatorUSE GO /****** Object: Operator Script Date: 8:23:14 PM ******/ EXEC _add_operator 3: -How to send email to multiple email accounts from SQL Server Agent Job if fails_updateOperator-How to look at Operator informationselect * from sysoperators -How to update operator to send email to multiple recipientsEXECUTE _update_operator = N'DBA', = Email to Multiple Email accounts From SQL Server Agent if Job Fails - DBA Tutorial It demonstrates using couple of methods.ġ- Send email to multiple accounts (recipients) using sp_send_dbmail store procedureĢ- Send email to multiple accounts (recipients) using configured Operator (SQL Server Agent Operator) In this video you will learn how to send email to multiple recipients (email addresses) if SQL Server Agent Job fails.
0 kommentar(er)
