SQL Server DBA Tutorial 126-Send Email to Multiple Email accounts From SQL Server Agent if Job Fails

preview_player
Показать описание
In this video you will learn how to send email to multiple recipients (email addresses) if SQL Server Agent Job fails. It demonstrates using couple of methods.
1- Send email to multiple accounts (recipients) using sp_send_dbmail store procedure
2- Send email to multiple accounts (recipients) using configured Operator (SQL Server Agent Operator)

Blog post link for the video with script

Visit our website to check out SQL Server DBA Tutorial Step by Step
  1. TechBrothersIT
  2. How to Send Email to Multiple Email accounts From SQL Server Agent if Job Fails
  3. SQL
  4. Server
  5. Developer
  6. DBA
Рекомендации по теме
SQL Server DBA 0:10:18

SQL Server DBA Tutorial 126-Send Email to Multiple Email accounts From SQL Server Agent if Job Fails

DBA Fundamentals: Configuration: 0:16:50

DBA Fundamentals: Configuration: Database Mail

How to Configure 0:10:50

How to Configure Database Mail | How to send Email from SQL SERVER | SQL

Send Email from 0:13:23

Send Email from SQL Server (Stored Procedures): SQL Express

SQL Server - 0:03:22

SQL Server - How to send an email in SQL Server | FoxLearn

How to send 0:10:57

How to send an email with dbMAIL, SQL/HTML and some basic job automation

Databases: Sending email 0:02:42

Databases: Sending email from SQL Server without using DBMail

Send Email From 0:01:33

Send Email From SQL Server - SQL in Sixty Seconds #039

How to Configure 0:05:22

How to Configure Database Mail | How to send Email from SQL SERVER | IQBees

How to Configure 0:06:25

How to Configure SQL Server Database Mail - SQL Server Database

SQL Server DBA 0:09:35

SQL Server DBA Tutorial 22 - How to Setup the Email Notificaion For Job Failure on SQL Server

Send Mail from 0:21:12

Send Mail from SQL Server

Database Mail Configuration 0:11:37

Database Mail Configuration in Microsoft SQL Server !! DBA Tasks !!

Configure SQL Server 0:04:56

Configure SQL Server Database Mail Using Gmail

How to configure 0:05:28

How to configure database mail in sql server using gmail

How To Report 0:02:38

How To Report SQL Jobs Failed report via email from SQL Server

SQL Server DBA 0:08:33

SQL Server DBA Tutorial 91-How to Create Server Level Trigger in SQL Server

How to configure 0:08:29

How to configure and send email using SQL server

4. Send Email 0:21:57

4. Send Email From SQL Server With Attachments

Databases: Send Email 0:01:42

Databases: Send Email when sql server agent job fails (2 Solutions!!)

How to configure 0:05:21

How to configure Database Mail in SQL Server

How to schedule 0:02:56

How to schedule a SQL query and send the result by mail

Send automated and 0:16:45

Send automated and scheduled emails in SQL Express

Creating SQL Server 0:05:06

Creating SQL Server alerts

Комментарии
Автор

I love this video because it's very useful for a DBA.
I enjoyed watching this video and recommend to others.

Bothe the steps has been clearly explained with examples.


Thanks for educating the community and appreciate your volunteership.

Thanks a lot

krismaly
Автор

Thanks for the video. Good content :):)

lakshayarora
Автор

Hello can you help me. I NEED add messages error generated by sql server to my steps notification. And view on my messages email inbox

Alekzanful
Автор

need help for this, I am pretty beginnerin sql: Create a Trigger to Auto-Email Whenever the Discount % in the SpecialOffer table in Adventure exceeds 80%.

sanazafshar
Автор

una duda! como puedo omitir el certifiado de seguridad cuando este es invalido?? me marca el siguiente error :

Mensaje de excepcion: no se pueden enviar los mensajes de correo al servidor de correo. (el certificado remoto no es válido según el procedimiento de validación)

drackster