{"id":414,"date":"2014-08-27T09:07:48","date_gmt":"2014-08-27T01:07:48","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=414"},"modified":"2014-08-27T09:07:48","modified_gmt":"2014-08-27T01:07:48","slug":"send-notification-two-operators-simultaneously","status":"publish","type":"post","link":"https:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html","title":{"rendered":"Send Notification to the two operators or more simultaneously"},"content":{"rendered":"<p>berikut ini saya coba memberikan sebuah trik bagaimana memberitahu 2 operator SQL Server mengenai sebuah Jobs yang telah dijalankan oleh SQL Server Agent.<!--more--><\/p>\n<p>Skenarionya adalah seperti ini : saya ada sebuah job untuk melakukan Complete Backup database AdventureWorks. Kemudian sukses atau tidaknya proses backup tersebut akan diberitahukan kepada 2 orang operator melalui email. Langkah-langkahnya adalah sebagai berikut :<\/p>\n<ol>\n<li>Pertama tentunya kita harus mengaktifkan fitur <a title=\"Configure Database Mail\" href=\"http:\/\/suherman.asia\/w2\/configure-database-mail.html\" target=\"_blank\"><span style=\"color: #0066cc;\">Database Mail<\/span> <\/a>di SQL Server nya. cara-cara mengaktifkannya dapat dilihat<a title=\"Configure Database Mail\" href=\"http:\/\/suherman.asia\/w2\/configure-database-mail.html\" target=\"_blank\"> <span style=\"color: #0066cc;\">disini<\/span>.<\/a><\/li>\n<li>Kemudian aktifkan SQL Server Agent Services nya.<\/li>\n<li>yang ketiga adalah tentunya menyiapkan 2 orang operatornya. setiap operator memiliki email sebagai media komunikasi atau notifikasinya.Operator 1 saya beri nama Operator1 yang memiliki email emantin34@yahoo.com.\u00a0 Operator 2 saya beri nama Operator2 yang memiliki email emantin34@hotmail.com. T-SQL nya seperti berikut :<\/li>\n<\/ol>\n<pre class=\"lang:tsql decode:true\">EXEC msdb.dbo.sp_add_operator\r\n @name=N'Operator1',\r\n         @enabled=1,\r\n         @email_address=N'emantin34@yahoo.com'\r\nGO\r\nEXEC msdb.dbo.sp_add_operator\r\n @name=N'Operator2',\r\n         @enabled=1,\r\n         @email_address=N'emantin34@hotmail.com'\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<p>Kemudian kita buat sebuah Maintanance Plan. Klik kanan pada Maintenance Plans dan pilih \u2018New Maintenance Plan..\u2019<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-415\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\" alt=\"26\" width=\"411\" height=\"326\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png 411w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26-300x237.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<p>lalu akan muncul gambar berikut<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-416\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/27.png\" alt=\"27\" width=\"390\" height=\"141\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/27.png 390w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/27-300x108.png 300w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/a><\/p>\n<p>Beri nama New Maintenance Plan ini dengan nama <strong>FullBackup_AdventureWorks_DB <\/strong>kemudian klik tombol OK. dari Maintenance Plan Desiger, pilih toolbox Backup Database Task<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-417\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/28.png\" alt=\"28\" width=\"411\" height=\"162\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/28.png 411w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/28-300x118.png 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<p>lalu drag n drop toolbox tersebut kedalam Maintenance Plan Designer dan akan tampak seperti ini<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-418\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/29.png\" alt=\"29\" width=\"328\" height=\"242\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/29.png 328w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/29-300x221.png 300w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/a><\/p>\n<p>klik 2 kali pada Backup Database Task tersebut tool tersebut, kemudian akan muncul Backup database Task Toll Properties. sesuaikan semua properties dengan tujuan kita yaitu melakukan Backup Full untuk database AdventureWorks. bila sudah selesai melakukan settingnya, maka akan tampak seperti berikut Backup Database Task nya<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-419\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/30.png\" alt=\"30\" width=\"335\" height=\"192\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/30.png 335w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/30-300x171.png 300w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/30-220x126.png 220w\" sizes=\"auto, (max-width: 335px) 100vw, 335px\" \/><\/a><\/p>\n<p>kemudian kita tambahkan lagi sebuah tool kedalam maintenance plan designer nya, yaitu Execute T-SQL Statement Task.<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/31.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-420\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/31.png\" alt=\"31\" width=\"373\" height=\"178\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/31.png 373w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/31-300x143.png 300w\" sizes=\"auto, (max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>lalu drag n drop kedalam Maintenance Plan Designer, lalu masukkan T-SQL Berikut ini<\/p>\n<pre class=\"lang:tsql decode:true \">declare @waktu as varchar(70)\r\nset @waktu='Report FullBackup AW SUKSES! pada '+\r\n       (select cast(GETDATE() as varchar(70)))\r\n\r\nEXECUTE msdb.dbo.sp_notify_operator \r\n@profile_name =N'AdminSuhermanPC',\r\n @name=N'operator1',\r\n@subject=N'Full Backup AW',\r\n@body=@waktu  \r\n\r\nEXECUTE msdb.dbo.sp_notify_operator \r\n@profile_name =N'AdminSuhermanPC', \r\n@name=N'operator2',\r\n@subject=N'Full Backup AW',\r\n@body=@waktu \r\n\r\nGO<\/pre>\n<p>lalu kita atur Workflow dari 2 Task yang sudah kita buat ini. kita coba buat untuk values Success. sehingga akan tampak seperti dibawah ini :<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-421\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/32.png\" alt=\"32\" width=\"360\" height=\"314\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/32.png 360w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/32-300x261.png 300w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<p>Setelah itu kita coba set Schedule dari Maintenance Plan ini. misalkan kita akan set bahwa Maintenance Plan ini akan dijalankan setiap hari pada pukul 23.00. caranya adalah dengan menset subplannya<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-422\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/33.png\" alt=\"33\" width=\"469\" height=\"157\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/33.png 469w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/33-300x100.png 300w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/><\/a><\/p>\n<p>klik pada icon sebelah kanan yang bergambar calendar. aturlah Frequency dan Daily Frequency nya.<\/p>\n<p>Sekarang kita lihat pada Object Explorer, dan lihat pada Job, ternyata sudah muncul subplan yang sudah kita set untuk Maintenance Plan yang sudah kita buat. Sekarang kita coba untuk melakukan test pada job ini dengan men-start Job tersebut<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-423\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/34.png\" alt=\"34\" width=\"464\" height=\"192\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/34.png 464w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/34-300x124.png 300w\" sizes=\"auto, (max-width: 464px) 100vw, 464px\" \/><\/a><\/p>\n<p>Lalu klik \u2018Start Job at Step\u2026\u2019 sehingga job yang sudah kita buat tersebut akan dijalankan<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/35.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-424\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/35.png\" alt=\"35\" width=\"349\" height=\"220\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/35.png 349w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/35-300x189.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><\/a><\/p>\n<p>Sekarang kita coba cek di Inbox setiap operator yang telah saya buat untuk membuktikan bahwa semua berjalan dengan semestinya<\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/36.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-425\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/36.png\" alt=\"36\" width=\"399\" height=\"177\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/36.png 399w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/36-300x133.png 300w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-426\" src=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/37.png\" alt=\"37\" width=\"409\" height=\"129\" srcset=\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/37.png 409w, https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/37-300x94.png 300w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/a><\/p>\n<p>Ternyata kedua operator tersebut telah berhasil menerima notifikasi full backup database AdventureWorks yang dikirim oleh SQL Server.<\/p>\n<p>Ok, selamat mencoba dan semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>berikut ini saya coba memberikan sebuah trik bagaimana memberitahu 2 operator SQL Server mengenai sebuah Jobs yang telah dijalankan oleh SQL Server Agent.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\">Continue reading<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[9,80,81],"class_list":["post-414","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-backup","tag-database-mail","tag-sql-server-job"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Send Notification to the two operators or more simultaneously - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send Notification to the two operators or more simultaneously - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"berikut ini saya coba memberikan sebuah trik bagaimana memberitahu 2 operator SQL Server mengenai sebuah Jobs yang telah dijalankan oleh SQL Server Agent. Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-27T01:07:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\" \/>\n\t<meta property=\"og:image:width\" content=\"411\" \/>\n\t<meta property=\"og:image:height\" content=\"326\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Send Notification to the two operators or more simultaneously\",\"datePublished\":\"2014-08-27T01:07:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\"},\"wordCount\":424,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\",\"keywords\":[\"Backup\",\"Database Mail\",\"SQL Server Job\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\",\"url\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\",\"name\":\"Send Notification to the two operators or more simultaneously - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage\"},\"thumbnailUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\",\"datePublished\":\"2014-08-27T01:07:48+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage\",\"url\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\",\"contentUrl\":\"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png\",\"width\":411,\"height\":326},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send Notification to the two operators or more simultaneously\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"https:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Send Notification to the two operators or more simultaneously - Suherman Blog","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":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html","og_locale":"en_US","og_type":"article","og_title":"Send Notification to the two operators or more simultaneously - Suherman Blog","og_description":"berikut ini saya coba memberikan sebuah trik bagaimana memberitahu 2 operator SQL Server mengenai sebuah Jobs yang telah dijalankan oleh SQL Server Agent. Continue reading","og_url":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-08-27T01:07:48+00:00","og_image":[{"width":411,"height":326,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Send Notification to the two operators or more simultaneously","datePublished":"2014-08-27T01:07:48+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html"},"wordCount":424,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage"},"thumbnailUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png","keywords":["Backup","Database Mail","SQL Server Job"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html","url":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html","name":"Send Notification to the two operators or more simultaneously - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage"},"thumbnailUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png","datePublished":"2014-08-27T01:07:48+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#primaryimage","url":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png","contentUrl":"https:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/26.png","width":411,"height":326},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/send-notification-two-operators-simultaneously.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Send Notification to the two operators or more simultaneously"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"https:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=414"}],"version-history":[{"count":1,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/414\/revisions"}],"predecessor-version":[{"id":427,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/414\/revisions\/427"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/415"}],"wp:attachment":[{"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}