{"id":11585,"date":"2019-04-14T09:17:28","date_gmt":"2019-04-14T09:17:28","guid":{"rendered":"https:\/\/dbtut.com\/?p=11585"},"modified":"2019-04-14T09:17:29","modified_gmt":"2019-04-14T09:17:29","slug":"how-to-send-an-email-after-failed-jobs","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/","title":{"rendered":"How To Send an Email After Failed Jobs"},"content":{"rendered":"

To send mail through the SQL Server, you must first configure Database Mail. You can find details in the article “How To Configure Database Mail On SQL Server<\/a>“.<\/p>\n

Let’s create a job after the Database Mail Configuration is completed. In my article “How To Create a SQL Server Job<\/a>” you can see how the job was created.<\/p>\n

From the SQL Server Agent section, click View Job Activity and right click on the XYZ job I created in the article I mentioned above and click on Properties. I’m accessing step’s content by clicking edit in the “Steps” section. I’m writing the wrong TSQL code as follows for Job to fail.<\/p>\n

\"\"<\/p>\n

Then we mark the E-mail in Notifications and we select the Operator we defined in the Database Mail Configuration from the check box next to it.<\/p>\n

“When the Job fails” remains selected. In this way, it will send an e-mail to the people defined in Operator if the job fails.<\/p>\n

\"\"<\/p>\n

I’m running the job to do the test and when the job gets the error, it sends me a mail as follows.<\/p>\n

\"\"<\/p>\n[the_ad id=”855″<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

To send mail through the SQL Server, you must first configure Database Mail. You can find details in the article “How To Configure Database Mail On SQL Server“. Let’s create a job after the Database Mail Configuration is completed. In my article “How To Create a SQL Server Job” you can see how the job …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":11592,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[3385,3379,3380,3381,3391,3390,3383,3382,3378,3384,3393,3395,3394,3392,3388,3387,3386,3389,3396],"class_list":["post-11585","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-create-sql-job-to-send-email","tag-email-notification","tag-email-notification-for-failed-jobs","tag-email-notification-for-jobs","tag-failed-to-notify-dbas-via-email","tag-how-do-i-add-an-email-notification-in-sql-server","tag-how-to-send-email-after-job-fail","tag-how-to-set-up-database-mail-for-sql-server-job-failures","tag-send-an-email-notification-when-sql-job-fails","tag-send-email-from-sql-server-agent-job","tag-send-email-to-dba-team","tag-send-email-to-dba-team-after-failed-jobs","tag-send-email-to-dba-team-after-jobs-failures","tag-send-mail-on-job-failures","tag-sql-job-failed-to-notify-via-email","tag-sql-job-step-failure-notification","tag-sql-server-agent-jobs-notifications-email","tag-sql-server-unable-to-send-job-completion-notification-email-to-operator","tag-when-the-jobs-fails-send-an-email-to-dba-team"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":511,"today_views":0},"yoast_head":"\nHow To Send an Email After Failed Jobs - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Send email After Failed Jobs\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Send an Email After Failed Jobs - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Send email After Failed Jobs\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-14T09:17:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-14T09:17:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png\" \/>\n\t<meta property=\"og:image:width\" content=\"643\" \/>\n\t<meta property=\"og:image:height\" content=\"328\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Send an Email After Failed Jobs\",\"datePublished\":\"2019-04-14T09:17:28+00:00\",\"dateModified\":\"2019-04-14T09:17:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\"},\"wordCount\":192,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png\",\"keywords\":[\"create sql job to send email\",\"Email notification\",\"Email notification for failed jobs\",\"Email notification for jobs\",\"Failed to notify DBAs via email\",\"How do I add an email notification in SQL Server?\",\"How to send email after job fail\",\"How to Set Up Database Mail for SQL Server Job Failures\",\"Send An Email Notification When SQL Job Fails\",\"send email from sql server agent job\",\"send email to dba team\",\"send email to dba team after failed jobs\",\"send email to dba team after jobs failures\",\"send mail on job failures\",\"sql job failed to notify via email\",\"sql job step failure notification\",\"sql server agent jobs notifications email\",\"sql server unable to send job completion notification email to operator\",\"when the jobs fails send an email to dba team\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\",\"name\":\"How To Send an Email After Failed Jobs - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png\",\"datePublished\":\"2019-04-14T09:17:28+00:00\",\"dateModified\":\"2019-04-14T09:17:29+00:00\",\"description\":\"How To Send email After Failed Jobs\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png\",\"width\":643,\"height\":328},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Send an Email After Failed Jobs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Send an Email After Failed Jobs - Database Tutorials","description":"How To Send email After Failed Jobs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/","og_locale":"en_US","og_type":"article","og_title":"How To Send an Email After Failed Jobs - Database Tutorials","og_description":"How To Send email After Failed Jobs","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-14T09:17:28+00:00","article_modified_time":"2019-04-14T09:17:29+00:00","og_image":[{"width":643,"height":328,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Send an Email After Failed Jobs","datePublished":"2019-04-14T09:17:28+00:00","dateModified":"2019-04-14T09:17:29+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/"},"wordCount":192,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png","keywords":["create sql job to send email","Email notification","Email notification for failed jobs","Email notification for jobs","Failed to notify DBAs via email","How do I add an email notification in SQL Server?","How to send email after job fail","How to Set Up Database Mail for SQL Server Job Failures","Send An Email Notification When SQL Job Fails","send email from sql server agent job","send email to dba team","send email to dba team after failed jobs","send email to dba team after jobs failures","send mail on job failures","sql job failed to notify via email","sql job step failure notification","sql server agent jobs notifications email","sql server unable to send job completion notification email to operator","when the jobs fails send an email to dba team"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/","name":"How To Send an Email After Failed Jobs - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png","datePublished":"2019-04-14T09:17:28+00:00","dateModified":"2019-04-14T09:17:29+00:00","description":"How To Send email After Failed Jobs","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-30.png","width":643,"height":328},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Send an Email After Failed Jobs"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11585"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11585\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11592"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}