{"id":10044,"date":"2024-08-26T22:11:24","date_gmt":"2024-08-26T13:11:24","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=10044"},"modified":"2024-08-26T22:11:26","modified_gmt":"2024-08-26T13:11:26","slug":"post-10044","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2024\/08\/26\/post-10044\/","title":{"rendered":"SQL Server \u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u30e1\u30fc\u30eb\u9001\u4fe1\u3059\u308b"},"content":{"rendered":"\n

SQL Server\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u5834\u5408\u306f\u3001\u300cMSDB.DBO.SP_SEND_DBMAIL\u300d\u3092\u4f7f\u7528\u3059\u308b\u3002<\/p>\n\n\n\n

MSDB.DBO.SP_SEND_DBMAIL<\/code><\/pre>\n\n\n\n
\u69cb\u6587\u7b49\uff1a\u3000https:\/\/learn.microsoft.com\/ja-jp\/sql\/relational-databases\/system-stored-procedures\/sp-send-dbmail-transact-sql?view=sql-server-ver16<\/a><\/p>\n\n\n\n
SQL Server\u304b\u3089\u30e1\u30fc\u30eb\u3092\u594f\u3059\u308b\u305f\u3081\u306e SMTP\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a\u306b\u3064\u3044\u3066\u306f\u3001\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30e1\u30fc\u30eb\u300d\u300cDatabase Mail\u300d\u3092\u5225\u9014\u8a2d\u5b9a\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n\n\n\n
SSMS\u306eGUI\u3067\u8a2d\u5b9a\u3059\u308b\u306e\u304c\u697d\u3067\u3001\u5de6\u306e\u30c4\u30ea\u30fc\u3067\u300c\u7ba1\u7406\u300d\u306e\u4e0b\u306b\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30e1\u30fc\u30eb\u300d\u304c\u3042\u308b\u306e\u3067\u300c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30e1\u30fc\u30eb\u306e\u69cb\u6210\u300d\u3092\u9078\u629e\u3057\u3066\u3001\u30a6\u30a3\u30b6\u30fc\u30c9\u306b\u5f93\u3063\u3066\u8a2d\u5b9a\u3059\u308b\u3002<\/p>\n\n\n\n
\u53c2\u8003\uff1a\u3000https:\/\/sql55.com\/query\/send-email-from-sql-server.php<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
SQL Server\u306e\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u304b\u3089\u30e1\u30fc\u30eb\u3092\u9001\u4fe1\u3059\u308b\u5834\u5408\u306f\u3001\u300cMSDB.DBO.SP_SEND_DBMAIL\u300d\u3092\u4f7f\u7528\u3059\u308b\u3002 \u69cb\u6587\u7b49\uff1a\u3000https:\/\/learn.microsoft.com\/ja-jp\/sql\/rela […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7],"tags":[69,196],"class_list":["post-10044","post","type-post","status-publish","format-standard","hentry","category-windows","category-tech-memo","tag-sql-server","tag-sql-server-2019"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/10044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=10044"}],"version-history":[{"count":1,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/10044\/revisions"}],"predecessor-version":[{"id":10045,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/10044\/revisions\/10045"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=10044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=10044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=10044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}