Sign in
|
Join
Home
Blogs
Ask
Just Learned
Interview Questions
Puzzles
Tutorials
Quiz
Modules
Getting Started with Adobe After Effects - Part 6:
Motion Blur
Blogs
Upload Image
Close it
Select File
My blog on SQL Server, TSQL, MSBI and other areas of SQL Server.
Like
Invite Friends
Browse by Tags ·
View All
Cube in Sql Server..
2
RollUp
2
Groupby
2
Use of NULLIF
2
Procedures
2
Search Objects (Table Name
2
Happy diwali
1
SP_Rename
1
Bulk Insert
1
Completed 4 Years in IT Profession.........................................
1
Archive ·
View All
May 2012
10
June 2012
7
October 2012
3
July 2012
2
November 2012
1
September 2012
1
SQL Brain Box
Home
·
Posts
·
Most Liked
·
Most Discussed
·
Ask a Question
·
Fans (58)
·
Preferences
Send Mail Alert When Jobs are failed or Success?
May 14 2012 12:00AM
by
Nirav Gandhi
before read this post first visit following Posts:
1)
http://beyondrelational.com/modules/2/blogs/372/posts/14552/create-job-and-make-your-work-automated.aspx
2)
http://beyondrelational.com/modules/2/blogs/372/posts/14531/database-mail-configurations.aspx
Step 1) Open SSMS.First you have to Crate operator.Click on New Operator.
Step 2) Give Name and write your email-Id then click OK button.
Step 3) Please check Operator is Created or not?
Step 4) After Step 3 ,Please Right Click on Sql server Agent and open Properties.
Step 5) Go Alert System.please follow below image.and Click OK Button.
Step 6) After this Please open Job Properties.
Step 7) Go Notification tag and Check E-Mail and check you appropriate requirement. then click OK button.
After this when your job fails you got mail in configure Mail-Id.
Tags: 
Send Mail Alert When Jobs are failed or Success?
Previous:
Create Job and make your work automated.
Next:
Create User Define Role and Give Access
Nirav Gandhi
38 ·
5% ·
1503
0
Liked
0
Lifesaver
0
Refreshed
0
Learned
0
Incorrect
Like this
Post this to my facebook wall
Tweet this
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect
Submit
Your Comment
Sign Up
or
Login
to post a comment.
Copyright © Rivera Informatic Private Ltd
Contact us
Privacy Policy
Terms of use
Report Abuse
Advertising
[ZULU1097]