How to Send Email to Multiple Email accounts From SQL Server Agent if Job Fails - DBA Tutorial

In this video you will learn how to send email to multiple recipients (email addresses) if SQL Server Agent Job fails. It demonstrates using couple of methods.
1- Send email to multiple accounts (recipients) using sp_send_dbmail store procedure
2- Send email to multiple accounts (recipients) using configured Operator (SQL Server Agent Operator)


Scripts 1:

--How to send email to multiple email accounts from SQL Server Agent Job if fails_sp_send_dbmail
EXEC msdb.dbo.sp_send_dbmail
--Your profile name
    @profile_name = 'Techbrothers',
 --Your multiple recipients
    @recipients = 'email1@gmail.com;email2@yahoo.com',
    @body = 'Job Failed Please check ASAP',
    @subject = 'Job Failed on Production System' 

Script 2: 
--How to send email to multiple email accounts from SQL Server Agent Job if fails_addOperator
USE [msdb]
GO

/****** Object:  Operator [DBA]    Script Date: 4/13/2015 8:23:14 PM ******/
EXEC msdb.dbo.sp_add_operator @name=N'DBA', 
  @enabled=1, 
  @weekday_pager_start_time=80000, 
  @weekday_pager_end_time=235900, 
  @saturday_pager_start_time=90000, 
  @saturday_pager_end_time=180000, 
  @sunday_pager_start_time=90000, 
  @sunday_pager_end_time=180000, 
  @pager_days=62, 
  @email_address=N'email1@gmail.com;Email2@yahoo.com', 
  @category_name=N'[Uncategorized]'
GO


Script 3:
--How to send email to multiple email accounts from SQL Server Agent Job if fails_updateOperator

  --How to look at Operator information
  select * from sysoperators
--How to update operator to send email to multiple recipients

EXECUTE msdb.dbo.sp_update_operator
  @name = N'DBA',
  @email_address = N'Email1@gmail.com;Email2@gmail.com'



Send Email to Multiple Email accounts From SQL Server Agent if Job Fails - DBA Tutorial

17 comments:

  1. Email checker or atomic email verifier software is all the same, and they go hand to hand with email marketing if you are talking about a large scale. To get the best out of your email marketing, you need to mix those two together to get the best flavours.

    ReplyDelete
  2. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles. hotmail.com

    ReplyDelete
  3. Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. saiba como acessar o site www.hotmail.com entrar

    ReplyDelete
  4. I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. entrar no hotmail

    ReplyDelete
  5. If you've got ever cursed your fax machine for its numerous paper jams or premature toner outages, sending e mail fax documents may additionally offer you with a simple answer for those commonplace ills.can you fax documents online

    ReplyDelete
  6. I am definitely enjoying your website. You definitely have some great insight and great stories. how to send a fax from my phone

    ReplyDelete
  7. This is why, once one spammer gets your email, you might begin receiving spam from all over the place. People are buying and selling your email address. email extractor from website

    ReplyDelete
  8. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this..........send fax from email
    send fax from email

    ReplyDelete
  9. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. send fax from phone

    ReplyDelete
  10. How about we perceive how every part of room furniture needs explicit consideration when you go out for shopping! CBT Bulk Email Sender Software

    ReplyDelete
  11. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. send and receive fax android

    ReplyDelete
  12. Gathering focused on URL's and the addresses that originate from them is the most ideal approach to get delivers that are valuable to your specific circumstance. CBT Mass Email Sender

    ReplyDelete
  13. HOW I GO MY DESIRED LOAN AMOUNT FROM A RELIABLE AND TRUSTED LOAN COMPANY LAST WEEK. Email for immediate response: drbenjaminfinance@gmail.com Call/Text: +1(415)630-7138 Whatsapp +19292227023

    Hello everyone, My name is Mr.Justin Riley Johnson, I am from Texas, United State, am here to testify of how i got my loan from BENJAMIN LOAN INVESTMENTS FINANCE(drbenjaminfinance@gmail.com) after i applied Two times from various loan lenders who claimed to be lenders right here this forum,i thought their lending where real and i applied but they never gave me loan until a friend of mine introduce me to {Dr.Benjamin Scarlet Owen} the C.E.O of BENJAMIN LOAN INVESTMENTS FINANCE who promised to help me with a loan of my desire and he really did as he promised without any form of delay, I never thought there are still reliable loan lenders until i met {Dr.Benjamin Scarlet Owen}, who really helped me with my loan and changed my life for the better. I don't know if you are in need of an urgent loan also, So feel free to contact Dr.Benjamin Scarlet Owen on his email address: drbenjaminfinance@gmail.com BENJAMIN LOAN INVESTMENTS FINANCE holds all of the information about how to obtain money quickly and painlessly via Whatsapp +19292227023 Email: drbenjaminfinance@gmail.com and consider all your financial problems tackled and solved. Share this to help a soul right now, Thanks..

    ReplyDelete
  14. Do you need an urgent loan of any kind? Loans to liquidate debts or need to loan to improve your business have you been rejected by any other banks and financial institutions? Do you need a loan or a mortgage? This is the place to look, we are here to solve all your financial problems. We borrow money for the public. Need financial help with a bad credit in need of money. To pay for a commercial investment at a reasonable rate of 3%, let me use this method to inform you that we are providing reliable and helpful assistance and we will be ready to lend you. Contact us today by email: daveloganloanfirm@gmail.com Call/Text: +1(501)800-0690 And whatsapp: +1 (315) 640-3560

    NEED A LOAN?
    Ask Me.

    ReplyDelete



  15. I FEEL LIKE CRYING AS I SHARE THIS TESIMONMY OF MINE Call me frank ...People of God i was recently laid off from a great job that was giving me food and shelter due to our bad economy . I registered on several job hunting sites and got busy fiinding another job. I came across several jobs but they didn't ...i then resolute to getting a loan online to pursue my long business dreams since i was having about $10,000 left from my savings and the entire cost for my business to kick off was billed at $50,000 which means that i needed $40,000 more to start this and i thought that going online would be better since most of them pose to grant loans at cheapest rate of %1 percent or less but i never realized that i was only digging my financial grave , low and behold i got brainwashed , deceived and even spell bound to sending all my left $10,000 to them for several fees , Omg , that was so heavy for me then because my family could barely feed trice delay after that incidence as we all grew lean and sickly . but i didn't give up as i knew that the worse thing that can happen to someone is to allow their dreams shattered due to a past failure , i told my lawyer and he advice specifically that there is a United State online based loan agency in the name of AMEIR MILLER LOAN AGENCY as they are currently offering loans now without any fear or problems simply because about 2 clients that he knows got loan from that firm as it is owned by a pastor , after hearing all this i prayed to God for his leading and also followed my lawyer's advice in which i applied but God actually showed his face as this God sent online loan agency granted me this loan funds within 48 hours without any form of problems or stories after i meant with their terms and conditions.indeed at an interest rate of %2 percent , ya all can go talk to them using these ameirmillerfinancialinstitute@gmail.com or ameirmillerclassicloaninstitute@yahoo.com , ameirmillerapprovedloans@usa.com God bless yall for taking out time to reading my message to the world .

    ReplyDelete



  16. I FEEL LIKE CRYING AS I SHARE THIS TESIMONMY OF MINE Call me frank ...People of God i was recently laid off from a great job that was giving me food and shelter due to our bad economy . I registered on several job hunting sites and got busy fiinding another job. I came across several jobs but they didn't ...i then resolute to getting a loan online to pursue my long business dreams since i was having about $10,000 left from my savings and the entire cost for my business to kick off was billed at $50,000 which means that i needed $40,000 more to start this and i thought that going online would be better since most of them pose to grant loans at cheapest rate of %1 percent or less but i never realized that i was only digging my financial grave , low and behold i got brainwashed , deceived and even spell bound to sending all my left $10,000 to them for several fees , Omg , that was so heavy for me then because my family could barely feed trice delay after that incidence as we all grew lean and sickly . but i didn't give up as i knew that the worse thing that can happen to someone is to allow their dreams shattered due to a past failure , i told my lawyer and he advice specifically that there is a United State online based loan agency in the name of AMEIR MILLER LOAN AGENCY as they are currently offering loans now without any fear or problems simply because about 2 clients that he knows got loan from that firm as it is owned by a pastor , after hearing all this i prayed to God for his leading and also followed my lawyer's advice in which i applied but God actually showed his face as this God sent online loan agency granted me this loan funds within 48 hours without any form of problems or stories after i meant with their terms and conditions.indeed at an interest rate of %2 percent , ya all can go talk to them using these ameirmillerfinancialinstitute@gmail.com or ameirmillerclassicloaninstitute@yahoo.com , ameirmillerapprovedloans@usa.com God bless yall for taking out time to reading my message to the world .

    ReplyDelete



  17. I FEEL LIKE CRYING AS I SHARE THIS TESIMONMY OF MINE Call me frank ...People of God i was recently laid off from a great job that was giving me food and shelter due to our bad economy . I registered on several job hunting sites and got busy fiinding another job. I came across several jobs but they didn't ...i then resolute to getting a loan online to pursue my long business dreams since i was having about $10,000 left from my savings and the entire cost for my business to kick off was billed at $50,000 which means that i needed $40,000 more to start this and i thought that going online would be better since most of them pose to grant loans at cheapest rate of %1 percent or less but i never realized that i was only digging my financial grave , low and behold i got brainwashed , deceived and even spell bound to sending all my left $10,000 to them for several fees , Omg , that was so heavy for me then because my family could barely feed trice delay after that incidence as we all grew lean and sickly . but i didn't give up as i knew that the worse thing that can happen to someone is to allow their dreams shattered due to a past failure , i told my lawyer and he advice specifically that there is a United State online based loan agency in the name of AMEIR MILLER LOAN AGENCY as they are currently offering loans now without any fear or problems simply because about 2 clients that he knows got loan from that firm as it is owned by a pastor , after hearing all this i prayed to God for his leading and also followed my lawyer's advice in which i applied but God actually showed his face as this God sent online loan agency granted me this loan funds within 48 hours without any form of problems or stories after i meant with their terms and conditions.indeed at an interest rate of %2 percent , ya all can go talk to them using these ameirmillerfinancialinstitute@gmail.com or ameirmillerclassicloaninstitute@yahoo.com , ameirmillerapprovedloans@usa.com God bless yall for taking out time to reading my message to the world .

    ReplyDelete