{"id":16094,"date":"2021-04-23T11:43:52","date_gmt":"2021-04-23T09:43:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/"},"modified":"2025-10-01T11:53:42","modified_gmt":"2025-10-01T09:53:42","slug":"sql-server-get-email-notifications-for-error-log-entries","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/","title":{"rendered":"SQL Server: Get email notifications for Error Log entries"},"content":{"rendered":"

Introduction<\/h4>\n

In a previous<\/a> blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes.
\nIn this one, you will see how to get nice emails from critical errors or specific events occurring on the instance using the ErrorLog.<\/p>\n

A common best practice for any DBA is to configure SQL Server Agent Alert for errors with severity 17 to 25.\"\"<\/a><\/p>\n

Alerts are also often set for less critical errors like “Login failed” (severity level 14).
\nEmails sent from Alerts are very basic and looks like this:\"\"<\/a><\/p>\n

All these errors are written to the SQL Server Error Log<\/a> file.\"\"<\/p>\n

The text message for these error messages that are logged into the Error Log can be found in the sys.messages<\/a> view.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
select<\/code> message_id, severity, text<\/code><\/div>\n
from<\/code> sys.messages <\/code><\/div>\n
where<\/code> (severity <\/code>between<\/code> 18 <\/code>and<\/code> 21<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>or<\/code> severity = 14)<\/code><\/div>\n
\u00a0\u00a0<\/code>and<\/code> is_event_logged = 1 <\/code><\/div>\n
\u00a0\u00a0<\/code>and<\/code> language_id = 1033<\/code><\/div>\n
order<\/code> by<\/code> severity;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

This query returns 174 rows on SQL Server version 2019.\"\"<\/a><\/p>\n

The error log files can be read using the stored procedure sp_reaerrorlog.<\/p>\n

Searching in the Error Log in SQL<\/h4>\n

The aim of the T-SQL script I am writing now is to replace Alerts with a job running every 5 minutes on my instance that will send me emails based on some messages I will define.<\/p>\n

Knowing all the information we’ve seen before, I can build a table variable with the text that I want to look for in the ErrorLog, whether it is critical errors or informational messages.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
DECLARE<\/code> @errorlog_definition <\/code>TABLE<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>error_category <\/code>varchar<\/code>(150)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, error_pattern <\/code>varchar<\/code>(1000)<\/code><\/div>\n
)<\/code><\/div>\n
insert<\/code> into<\/code> @errorlog_definition<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>values<\/code> (<\/code>'Database Write Latency'<\/code>, <\/code>'%I\/O requests taking longer than%seconds to complete%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%cleaned up%bufs with%in%ms%for db%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%average%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%last target outstanding:%avgWriteLatency%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Error Disk Full'<\/code>, <\/code>'Could not allocate%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Login Failure'<\/code>, <\/code>'%Login Failed%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'SQL Server starting'<\/code>, <\/code>'SQL Server is starting%'<\/code>)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The first column is the type of event I want to be emailed about and will be used in the email title.<\/p>\n

The current error log entries are inserted in another table variable.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
insert<\/code> into<\/code> @errorlog<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>exec<\/code> sp_readerrorlog 0<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now, using a CROSS APPPY I can get only the Error Log entries matching my messages patterns.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
select<\/code> e.LogDate, e.ProcessInfo, e.Text, c.error_category<\/code><\/div>\n
from<\/code> @errorlog <\/code>AS<\/code> e<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>cross<\/code> apply (<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> *<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>from<\/code> @errorlog_definition <\/code>AS<\/code> d<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>where<\/code> e.Text <\/code>like<\/code> d.error_pattern<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>) <\/code>AS<\/code> c<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\"\"<\/a><\/p>\n

I managed to get only the Error Log entries I want. Entries are categorized and I decided not to send just one email every time the job runs but once for every category.<\/p>\n

I did this with cursors. Here is the whole script if you want to try it.<\/p>\n

Script<\/h4>\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n
97<\/div>\n
98<\/div>\n
99<\/div>\n
100<\/div>\n
101<\/div>\n
102<\/div>\n
103<\/div>\n
104<\/div>\n
105<\/div>\n
106<\/div>\n
107<\/div>\n
108<\/div>\n
109<\/div>\n
110<\/div>\n
111<\/div>\n
112<\/div>\n
113<\/div>\n
114<\/div>\n
115<\/div>\n
116<\/div>\n
117<\/div>\n
118<\/div>\n
119<\/div>\n
120<\/div>\n
121<\/div>\n
122<\/div>\n
123<\/div>\n
124<\/div>\n
125<\/div>\n
126<\/div>\n
127<\/div>\n
128<\/div>\n
129<\/div>\n
130<\/div>\n
131<\/div>\n
132<\/div>\n
133<\/div>\n
134<\/div>\n
135<\/div>\n<\/td>\n
\n
\n
--\u00a0 Job frequency<\/code><\/div>\n
DECLARE<\/code> @CheckPeriodInMinute <\/code>int<\/code> = 5<\/code><\/div>\n
<\/div>\n
--\u00a0 Variables<\/code><\/div>\n
DECLARE<\/code> @colldate datetime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @object <\/code>varchar<\/code>(1024)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @HTML_footer <\/code>varchar<\/code>(<\/code>max<\/code>)\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @HTML_header <\/code>varchar<\/code>(<\/code>max<\/code>)\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @HTML <\/code>varchar<\/code>(<\/code>max<\/code>)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @HTML_part <\/code>varchar<\/code>(<\/code>max<\/code>)\u00a0\u00a0\u00a0 <\/code><\/div>\n
<\/div>\n
DECLARE<\/code> @errorlog <\/code>TABLE<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>LogDate datetime<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, ProcessInfo <\/code>varchar<\/code>(32)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, Text <\/code>varchar<\/code>(<\/code>max<\/code>)<\/code><\/div>\n
)<\/code><\/div>\n
DECLARE<\/code> @notifiable_errors <\/code>table<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>LogDate <\/code>varchar<\/code>(19)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, ProcessInfo <\/code>varchar<\/code>(32)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, Text <\/code>varchar<\/code>(1024)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, error_category <\/code>varchar<\/code>(150)<\/code><\/div>\n
)<\/code><\/div>\n
<\/div>\n
SELECT<\/code> @HTML_header=<\/code>'<\/code><\/div>\n
<head><\/code><\/div>\n
<style type=\"text\/css\"><\/code><\/div>\n
table {border: 1px solid #1C6EA4;background-color: #EEEEEE;width: 100%;text-align: left;border-collapse: collapse;}<\/code><\/div>\n
table td, table th {border: 1px solid #AAAAAA;padding: 3px 2px;}<\/code><\/div>\n
table tbody td {font-size: 13px;}<\/code><\/div>\n
table thead {background: #1C6EA4;border-bottom: 2px solid #444444;}<\/code><\/div>\n
table thead th {font-size: 15px;font-weight: bold;color: #FFFFFF;border-left: 2px solid #D0E4F5;}<\/code><\/div>\n
table thead th:first-child {border-left: none;}<\/code><\/div>\n
h1\u00a0\u00a0\u00a0\u00a0\u00a0 {font:bold 16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:15pt; margin-bottom:0pt; padding:0px 0px 0px 0px;}<\/code><\/div>\n
<\/style><\/code><\/div>\n
<\/head><\/code><\/div>\n
<body><\/code><\/div>\n
<a name=\"top\"><\/a>'<\/code><\/div>\n
<\/div>\n
set<\/code> @HTML_footer=<\/code>'<p><i>Executed on '<\/code>+<\/code>convert<\/code>(<\/code>varchar<\/code>,getdate(),120)+<\/code>' from server \"'<\/code>+<\/code>isnull<\/code>(<\/code>convert<\/code>(<\/code>varchar<\/code>(128),@@SERVERNAME),<\/code>''<\/code>)+<\/code>'\"<\/i><\/p>'<\/code><\/div>\n
<\/div>\n
--\u00a0 ----<\/code><\/div>\n
DECLARE<\/code> @errorlog_definition <\/code>TABLE<\/code>(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>error_category <\/code>varchar<\/code>(150)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, error_pattern <\/code>varchar<\/code>(1000)<\/code><\/div>\n
)<\/code><\/div>\n
insert<\/code> into<\/code> @errorlog_definition<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>values<\/code> (<\/code>'Database Write Latency'<\/code>, <\/code>'%I\/O requests taking longer than%seconds to complete%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%cleaned up%bufs with%in%ms%for db%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%average%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Latency'<\/code>, <\/code>'%last target outstanding:%avgWriteLatency%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Write Error Disk Full'<\/code>, <\/code>'Could not allocate%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'Database Login Failure'<\/code>, <\/code>'%Login Failed%'<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,(<\/code>'SQL Server starting'<\/code>, <\/code>'SQL Server is starting%'<\/code>)<\/code><\/div>\n
<\/div>\n
insert<\/code> into<\/code> @errorlog<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>exec<\/code> sp_readerrorlog 0<\/code><\/div>\n
<\/div>\n
-- Get Error Log entries matching pattern (like)<\/code><\/div>\n
insert<\/code> into<\/code> @notifiable_errors<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> e.LogDate, e.ProcessInfo, e.Text, c.error_category<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>from<\/code> @errorlog <\/code>AS<\/code> e<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>cross<\/code> apply (<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> *<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>from<\/code> @errorlog_definition <\/code>AS<\/code> d<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>where<\/code> e.Text <\/code>like<\/code> d.error_pattern<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>) <\/code>AS<\/code> c<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>where<\/code> LogDate > DATEADD(<\/code>MINUTE<\/code>, -@CheckPeriodInMinute, GETDATE())<\/code><\/div>\n
<\/div>\n
-- If any rows to process<\/code><\/div>\n
if @@ROWCOUNT>0<\/code><\/div>\n
begin<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> @logdate datetime<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> @processInfo <\/code>varchar<\/code>(32)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> @Text <\/code>varchar<\/code>(<\/code>MAX<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> @error_category <\/code>varchar<\/code>(150)<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> category_cursor <\/code>CURSOR<\/code> FOR<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> distinct<\/code> error_category<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>from<\/code> @notifiable_errors<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>OPEN<\/code> category_cursor\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FETCH<\/code> NEXT<\/code> FROM<\/code> category_cursor <\/code>INTO<\/code> @error_category<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>WHILE @@FETCH_STATUS = 0\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>BEGIN<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>-- Loops 1 time per category<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>-- Email Object + HTML Table header<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>SELECT<\/code> @object = @error_category+<\/code>' - Last '<\/code>+<\/code>convert<\/code>(<\/code>varchar<\/code>(50),@CheckPeriodInMinute)+<\/code>' min ('<\/code>+<\/code>convert<\/code>(<\/code>varchar<\/code>(<\/code>max<\/code>),@@servername)+<\/code>')'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>SELECT<\/code> @HTML=@HTML_header+<\/code>'<h1>'<\/code>+@error_category+<\/code>' (last '<\/code>+<\/code>convert<\/code>(<\/code>varchar<\/code>(50),@CheckPeriodInMinute)+<\/code>' min)<\/h1>'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>SELECT<\/code> @HTML=@HTML+<\/code>'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><table><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><tr><th>LogDate<\/th><th>ProcessInfo<\/th><th>Text<\/th><\/tr><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>--\u00a0 ----<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>--\u00a0 Cursor: Get all entries for the current category<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>--\u00a0 Create HTML Table rows<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>--\u00a0 ----<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>DECLARE<\/code> error_cursor <\/code>CURSOR<\/code> FOR<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> LogDate, ProcessInfo, Text<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>from<\/code> @notifiable_errors<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>where<\/code> error_category = @error_category<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>OPEN<\/code> error_cursor\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>FETCH<\/code> NEXT<\/code> FROM<\/code> error_cursor <\/code>INTO<\/code> @logdate, @processInfo, @Text<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>WHILE @@FETCH_STATUS = 0\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>BEGIN<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>-- HTML Table rows<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>select<\/code> @HTML_part = <\/code>'<tr><td>'<\/code>+<\/code>isnull<\/code>(<\/code>convert<\/code>(<\/code>varchar<\/code>,@logdate,120),<\/code>''<\/code>)+<\/code>'<\/td><td>'<\/code>+<\/code>isnull<\/code>(@processInfo,<\/code>''<\/code>)+<\/code>'<\/td><td>'<\/code>+<\/code>isnull<\/code>(@Text,<\/code>''<\/code>)+<\/code>'<\/td><\/tr>'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>set<\/code> @HTML=@HTML+@HTML_part+<\/code>'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>'<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>FETCH<\/code> NEXT<\/code> FROM<\/code> error_cursor <\/code>INTO<\/code> @logdate, @processInfo, @Text;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>END<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>CLOSE<\/code> error_cursor\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>DEALLOCATE<\/code> error_cursor <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>-- HTML Table end + send email<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>set<\/code> @HTML=@HTML+<\/code>'<\/table><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>'<\/code>+@HTML_footer<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>EXEC<\/code> msdb.dbo.sp_send_dbmail<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>@profile_name = <\/code>'DBA_Profile'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @subject= @object <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @recipients = <\/code>'sql@DBA.local'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @body_format=<\/code>'html'<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>, @body = @HTML<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>FETCH<\/code> NEXT<\/code> FROM<\/code> category_cursor <\/code>INTO<\/code> @error_category;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>END<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CLOSE<\/code> category_cursor\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>DEALLOCATE<\/code> category_cursor <\/code><\/div>\n
end<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Email examples<\/h4>\n

Here are some emails sent by this Job.<\/p>\n

On SQL Server start:\"\"<\/a>On Failed login:\"\"<\/a><\/p>\n

Conclusion<\/h4>\n

The drawback of this approach is that I have to know exactly what I want to get emailed about. If I don’t use Agent Alerts I might miss some critical errors.
\nWhat is nice is that I can look for informational messages and not only errors.
\nI hope you found this interesting and it gave you some ideas on how to get information from your SQL Server instances.<\/p>\n

Written by Steven Naudet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or specific events occurring on the instance using the ErrorLog. A common best practice for any DBA is […]<\/p>\n","protected":false},"author":26,"featured_media":16095,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[813,2317,2318,2550,521],"type_dbi":[],"class_list":["post-16094","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-alerts","tag-email","tag-error-log","tag-sql-server-2","tag-t-sql"],"acf":[],"yoast_head":"\nSQL Server: Get email notifications for Error Log entries - dbi 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=\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: Get email notifications for Error Log entries\" \/>\n<meta property=\"og:description\" content=\"Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or specific events occurring on the instance using the ErrorLog. A common best practice for any DBA is […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-23T09:43:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T09:53:42+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png\" \/>\n\t<meta property=\"og:image:width\" content=\"706\" \/>\n\t<meta property=\"og:image:height\" content=\"275\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server: Get email notifications for Error Log entries\",\"datePublished\":\"2021-04-23T09:43:52+00:00\",\"dateModified\":\"2025-10-01T09:53:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\"},\"wordCount\":422,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png\",\"keywords\":[\"Alerts\",\"email\",\"Error log\",\"SQL Server\",\"T-SQL\"],\"articleSection\":[\"Database Administration & Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\",\"name\":\"SQL Server: Get email notifications for Error Log entries - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png\",\"datePublished\":\"2021-04-23T09:43:52+00:00\",\"dateModified\":\"2025-10-01T09:53:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png\",\"width\":706,\"height\":275},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: Get email notifications for Error Log entries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: Get email notifications for Error Log entries - dbi 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":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: Get email notifications for Error Log entries","og_description":"Introduction In a previous blog post, I did a T-SQL script reading Audit files to send emails with valuable information about instance changes. In this one, you will see how to get nice emails from critical errors or specific events occurring on the instance using the ErrorLog. A common best practice for any DBA is […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/","og_site_name":"dbi Blog","article_published_time":"2021-04-23T09:43:52+00:00","article_modified_time":"2025-10-01T09:53:42+00:00","og_image":[{"width":706,"height":275,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server: Get email notifications for Error Log entries","datePublished":"2021-04-23T09:43:52+00:00","dateModified":"2025-10-01T09:53:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/"},"wordCount":422,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png","keywords":["Alerts","email","Error log","SQL Server","T-SQL"],"articleSection":["Database Administration & Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/","name":"SQL Server: Get email notifications for Error Log entries - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png","datePublished":"2021-04-23T09:43:52+00:00","dateModified":"2025-10-01T09:53:42+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Blog20_1_Alerts.png","width":706,"height":275},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-get-email-notifications-for-error-log-entries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: Get email notifications for Error Log entries"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16094"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16094\/revisions"}],"predecessor-version":[{"id":40609,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16094\/revisions\/40609"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16095"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16094"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}