{"id":279,"date":"2012-07-27T17:00:30","date_gmt":"2012-07-27T16:00:30","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=279"},"modified":"2012-08-14T14:37:13","modified_gmt":"2012-08-14T13:37:13","slug":"sql-agent-operators-recommended-setup","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2012\/07\/sql-agent-operators-recommended-setup\/","title":{"rendered":"SQL Agent Operators Recommended Setup"},"content":{"rendered":"<p>Database Mail should be configured on your SQL Server, if it isn&#8217;t get it done now there are no excuses, this is one of the main methods that can be used for finding out when there are issues with your SQL Server!<\/p>\n<p>It&#8217;s a good idea to setup an operator with a distribution email group email address so if a DBA leaves or moves onto another position the distribution group can be easily updated once in Active Directory as opposed to being updated on every SQL Server.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-280\" title=\"DBA Team Operator\" src=\"http:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamOperator.jpg\" alt=\"DBA Team Operator\" width=\"699\" height=\"154\" srcset=\"https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamOperator.jpg 699w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamOperator-300x66.jpg 300w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamOperator-500x110.jpg 500w\" sizes=\"auto, (max-width: 699px) 100vw, 699px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You could also create additional distribution\u00a0email groups and add them as operators this is useful if other administrators needs to be aware of certain Agent Jobs failing such as say BI Jobs.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter  wp-image-281\" title=\"DBA Team BI Operator\" src=\"http:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamBIOperator.jpg\" alt=\"DBA Team BI Operator\" width=\"698\" height=\"155\" srcset=\"https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamBIOperator.jpg 698w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamBIOperator-300x66.jpg 300w, https:\/\/www.darrencoupland.com\/blog\/wp-content\/uploads\/2012\/07\/DBATeamBIOperator-500x111.jpg 500w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Database Mail should be configured on your SQL Server, if it isn&#8217;t get it done now there are no excuses, this is one of the main methods that can be used for finding out when there are issues with your SQL Server!<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3,5],"tags":[29,16,60],"class_list":["post-279","post","type-post","status-publish","format-standard","hentry","category-dynamics-ax-2009","category-sql-server","tag-administration","tag-sql-agent","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=279"}],"version-history":[{"count":0,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/279\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}