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

20 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
  18. I want to use this medium to alert all loan seekers to be very careful because there are scam everywhere. Few months ago I was financially strained, and due to my desperation I was scammed by several online lenders. I had almost lost hope until a friend of mine referred me to a very reliable lender called Karin Sabine who lend me an unsecured loan of 10,000.00 Euro under 24Hours without any stress. If you are in need of any kind of loan just contact them now via email: sabinhelps@gmail.com or WhatsApp +79267494861.

    ReplyDelete


  19. ??DO YOU WANT TO RECOVER YOUR LOST FUNDS ON CAPITAL INVESTMENTS, BITCOIN INVESTMENTS, AND OTHER SCAM TRADING INVESTMENTS ??? TAKE YOUR TIME TO READ??

    ?? We have received numerous complaints of fraud associated with websites that offers opportunities for Capital Investments,
    bitcoin investments and Trading on an Internet-based trading platforms. Most Of The complaints falls into these Two categories:
    1. ??Refusal to credit customers accounts or reimburse funds to customers:
    These complaints typically involve customers who have deposited money into their trading or investment account and who are then encouraged
    by “brokers” over the telephone to deposit additional funds into the customer account.
    When customers later attempt to withdraw their original deposit or the return they have been promised, the trading platforms allegedly cancels customers’ withdrawal requests, refuse to credit their accounts, or ignore their telephone calls and emails.

    2. ??Manipulation of software to generate losing trades:
    These complaints allege that the Internet-based Investment and trading platforms manipulate the trading software to distort the Trading prices and payouts in order to ensure that the trade results in a Loss. For example, when a customer’s trade is “winning,” the countdown to expiration is extended arbitrarily until the trade becomes a loss.

    ?? Most people have lost their hard earned money through Scam Investments And Trading, yet they would go and meet fake recovery Experts unknowingly to help them recover their money and they would end up losing more money in the process. This Is Basically why we (Thehackerspro.com) have come to y’all victim’s rescue. The clue is most of these Brokers have weak Database security, and their vulnerabilities can be exploited easily with the Help of our Special HackTools, Root HackTools And Technical Hacking Strategies because they wouldn’t wanna spend money in the sponsorship of Bug bounty Programs which would have helped protect their Database from Unauthorized access to their Database, So all our specialists do is to hack into the Broker’s Database via SQL Hook injections & DNS Spoofing, Decrypt your Transaction Details, Trace the Routes of your Deposited Funds, Then some Technical Hacking Algorithms & Execution Which we cant explain here would follow then you have your money recovered. ?? ??

    ??All our Specialists are well experienced in their various niches with Great Skills, Technical Hacking Strategies And Positive Online Reputations And Recommendations??
    They hail from a proven track record and have cracked even the toughest of barriers to intrude and capture all relevant data needed by our Clients.
    We have Digital Forensic Specialists, Certified Ethical Hackers, Software Engineers, Cyber Security Experts, Private investigators and more. Our Goal is to make your digital life secure, safe and hassle free by Linking you Up With these great Professionals such as JACK CABLE, ARNE SWINNEN, SEAN MELIA, DAWID CZAGAN, BEN SADEGHIPOUR And VLADIMIR KOLAROV More. These Professionals are Well Reserved Professionals who are always ready to Handle your job with great energy and swift response so that your problems can be solved very quickly.
    All You Need to Do is to send us a mail or talk with support on the website who will set you up for a schedule and we’ll Assign any of these specialists to Handle your Job immediately.

    ?? Below Is A Full List Of Our Services:
    * FUNDS RECOVERY ON INVESTMENT AND TRADING.
    * WEBSITE HACKING
    * CREDIT REPAIR.
    * PHONE HACKING (giving you Unnoticeable access to everything Happening on the Target’s Phone)
    * CLEARING OF CRIMINAL RECORDS
    * SOCIAL MEDIA ACCOUNTS HACKING


    ?? CONTACT:
    ••• Email:
    int.hackers002@gmail.com


    ??2021 © Mikefisher
    ??Want faster service? Contact us!
    ??All Rights Reserved ®?

    ReplyDelete

  20. Tried a lot of hackers but i strongly recommend thehackerspro.com where i eventually hired the dreaded darkhat hacker vladimir kolarov
    although he was much more expensive than other hackers i contacted but he did a good job and their customer support on the website is friendly and very helpful.
    These are ethical hackers that’ll solve all your problems like hack emails,Facebook, Twitter ,Instagram , change grades ,
    erase criminal records, credit and debit top up, insurance paper,
    access or recover lost files, background checks on individuals and organizations
    or monitor cheating spouses’ phone or social media activities, contact at h4ckerspro@gmail.com or call/text 1 646 948 8125.
    for faster and direct access just add him on telegram @h4ckerspro

    ReplyDelete