• Skip to navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

SQL Swampland

  • Home
  • Business Intelligence
  • Training
  • Career Advice
  • Random Musings
  • About SQLGator
Twitter RSS Feed

Blog Archives

Fail-Safe Operator

Sep 18

Posted by SQLGator

Everyone needs a backup plan including the SQL Server notifications. If something goes awry with the notifications or the msdb database is unreachable, then the fail-safe operator will ensure that mail is delivered.

Select properties on the SQL Server agent (from the object explorer) in order to enable it for your instance. Enjoy!

Fail Safe Operator

Share my stuff:

  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to share on Telegram (Opens in new window) Telegram
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on WhatsApp (Opens in new window) WhatsApp
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to email a link to a friend (Opens in new window) Email
  • Click to print (Opens in new window) Print
Like Loading...

Posted in Maintenance, Troubleshooting

Leave a comment

Tags: Configuration, Notifications

  • SQLGator aka Ed Watson

    Unknown's avatar

  • Microsoft Data Platform MVP Since 2014

    SQL Server Microsoft MVP Since 2014
  • Principal Consultant for Improving Atlanta

    11675 Rainwater Dr., Suite 100, Alpharetta, GA 30009
    1-770-623-5734
    ed.watson@improving.com
    https://improving.com/location/atlanta
  • Certifications

  • Enter your email address to follow this blog and receive notifications of new posts by email.

    Join 47 other subscribers
  • Search the Swampland

  • Categories

    AlwaysOn Auditing Business Intelligence Career Advice Database Administration Tasks Design Funhouse Goals Installation Lessons Learned Maintenance Migration Monitoring Performance Tuning Personal Development Plan PowerBI Random Musings Scripting Security Social Media SQL PASS SQL Saturday SQL Schoolhouse SSIS Training Travel Troubleshooting Upgrading Workplace
  • #SQLScuba

    #SQLScuba
  • Most Popular Posts

    • SQL Schoolhouse
    • Final Thought from SQL Saturday Pensacola Pre-Con
    • Saving Time with SQL Server Migration Assistant for Oracle
    • Question of the Day Twenty-Five
    • Outlook Rules Are Your Friend
    • Replication Series, Part Four: Snapshot Replication
    • SQL Server Domination Plan Phase One Has Completed
    • Recent Comments
    • Popular Posts
    • Archives
    • Tags
    • Categories
    • Unknown's avatarI've never experienced anything like the SQL Community before.
    • John Smith's avatarJohn SmithGreatt read thank you
    • Connor Ritter's avatarConnor RitterGreat reading youur blog
    • Caroline G's avatarCaroline GGreeat share
    • T-SQL Tuesday #41 Recap | Bob Pusateri[…] Watson (@SQLGator) tells us that he’s not in love with presenting – yet
    • SQL Server Domination Plan Phase One Has Completed (6)
    • Saddened #WIT (5)
    • Transaction Log Fills Up the Drive….Oh No! (4)
    • Personal Development Plan Part Dos…. (4)
    • SQL Nexus, Quirkiness Continued (4)
    • And so it begins….. (4)
    • SQL Tool Evaluation, List of Tools (4)
    • DBAs, MCMs and MVPs, Oh My! (3)
    • SQL and Nothing Else? (3)
    • Changing the Change Management (3)
    • June 2020 (1)
    • September 2018 (1)
    • August 2018 (1)
    • July 2018 (1)
    • June 2018 (1)
    • May 2018 (1)
    • April 2018 (1)
    • October 2017 (2)
    • June 2017 (1)
    • May 2017 (1)
    • April 2017 (1)
    • March 2017 (9)
    • February 2017 (5)
    • December 2015 (1)
    • October 2015 (1)
    • September 2015 (1)
    • August 2015 (1)
    • July 2015 (1)
    • January 2015 (2)
    • September 2014 (1)
    • August 2014 (2)
    • June 2014 (1)
    • January 2014 (1)
    • November 2013 (1)
    • October 2013 (2)
    • September 2013 (2)
    • August 2013 (2)
    • July 2013 (3)
    • June 2013 (4)
    • May 2013 (4)
    • April 2013 (5)
    • March 2013 (14)
    • February 2013 (11)
    • January 2013 (22)
    • December 2012 (28)
    • November 2012 (30)
    • October 2012 (30)
    • September 2012 (30)
    • August 2012 (31)
    • July 2012 (32)
    • June 2012 (30)
    • May 2012 (31)
    • April 2012 (30)
    • March 2012 (31)
    • February 2012 (29)
    • January 2012 (31)
    • December 2011 (3)
    • November 2011 (5)
    #SQLFamily #SQLKaraoke Activity Monitoring Auditing Backup and Recovery Best Practices BPA Certification Family Goals happy new year Holiday Installation Maintenance MCITP MCM MCTS migration PASS Summit Performance Monitoring PowerBI Random Replication Seattle security SQLDiag SQL Fun SQL Learning SQL Nexus SQL Pass SQL Saturday sql server 2005 SQL Server 2008 SQL Server 2008R2 SQL Server 2012 SSMS Summit Summit 2012 T-SQL Tampa Tampa Bay SQL Server Users Group Training Travel Troubleshooting Vacation
    • Business Intelligence (26)
      • PowerBI (25)
      • SSIS (1)
    • Career Advice (81)
      • Goals (38)
      • Personal Development Plan (35)
    • Database Administration Tasks (151)
      • AlwaysOn (7)
      • Auditing (12)
      • Design (1)
      • Installation (12)
      • Maintenance (61)
      • Migration (10)
      • Monitoring (25)
      • Performance Tuning (2)
      • Scripting (19)
      • Security (14)
      • Troubleshooting (25)
      • Upgrading (10)
    • Funhouse (25)
    • Lessons Learned (9)
    • Random Musings (59)
    • Social Media (4)
    • Training (166)
      • SQL PASS (45)
      • SQL Saturday (51)
      • SQL Schoolhouse (57)
    • Travel (19)
    • Workplace (2)
  • RSS Feeds

    • RSS - Posts
    • RSS - Comments
  • Archives

    • June 2020 (1)
    • September 2018 (1)
    • August 2018 (1)
    • July 2018 (1)
    • June 2018 (1)
    • May 2018 (1)
    • April 2018 (1)
    • October 2017 (2)
    • June 2017 (1)
    • May 2017 (1)
    • April 2017 (1)
    • March 2017 (9)
    • February 2017 (5)
    • December 2015 (1)
    • October 2015 (1)
    • September 2015 (1)
    • August 2015 (1)
    • July 2015 (1)
    • January 2015 (2)
    • September 2014 (1)
    • August 2014 (2)
    • June 2014 (1)
    • January 2014 (1)
    • November 2013 (1)
    • October 2013 (2)
    • September 2013 (2)
    • August 2013 (2)
    • July 2013 (3)
    • June 2013 (4)
    • May 2013 (4)
    • April 2013 (5)
    • March 2013 (14)
    • February 2013 (11)
    • January 2013 (22)
    • December 2012 (28)
    • November 2012 (30)
    • October 2012 (30)
    • September 2012 (30)
    • August 2012 (31)
    • July 2012 (32)
    • June 2012 (30)
    • May 2012 (31)
    • April 2012 (30)
    • March 2012 (31)
    • February 2012 (29)
    • January 2012 (31)
    • December 2011 (3)
    • November 2011 (5)

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • SQL Swampland
    • Join 47 other subscribers
    • Already have a WordPress.com account? Log in now.
    • SQL Swampland
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    %d