CODEWITHSUNDEEP
sql-serversql-server-2008ssms
Vegeta_77
Vegeta_77

Reputation: 464

SQL Server 2008 R2 / E-Mail if job doesn't run

In SQL Server 2008 R2 / Management Studio, I have a Job. The Job runs every day at 6:00 am. Sometimes the Job is crashing. I know taht it is possible to configure an E-Mail, if the job wasn't run.

How do I that and where? In Management Studio or directly on the Server 2008 R2?

THX.

Greetz Vegeta

Upvotes: 0

Views: 44

Answers (1)

JamieA
JamieA

Reputation: 2013

In SSMS, go to management, then right click Database mail, and Configure Database Mail. Here you need to set up a mail profile and enter your mail server details.

In SSMS, go to SQL Server Agent, then right click properties, and configure Alert System to Enable mail profile. SQL Server Agent must be restarted for this to take affect.

Now, in the SQL agent job properties, go to notifications, and you can select to email an account within your mail profile if a job fails

Upvotes: 1

Related Questions