Send email notification for Scheduled Job completion
This is a discussion on Send email notification for Scheduled Job completion within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi, I wanted to know how can we send out email notification for the Jobs that are completed. Thanks ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:39 AM
| |||
| |||
 Re: Send email notification for Scheduled Job completion aj70000@hotmail.com (AJ) wrote in message news:<6097f505.0404281441.8e46738@posting.google.c om>... > Hi, > > I wanted to know how can we send out email notification for the Jobs > that are completed. > > Thanks a lot in advance.... > > AJ You can set up SQL Mail, create an Operator to notify, and send an email on job success. Or execute a batch file when the job succeeds which calls an external email script. See Books Online for more information on SQL Mail and operators, and this link my be useful: http://support.microsoft.com/default...b;EN-US;263556 Simon      |
|
02-29-2008, 02:39 AM
| ||||
| ||||
| Re: Send email notification for Scheduled Job completion aj70000@hotmail.com (AJ) wrote in message news:<6097f505.0404281441.8e46738@posting.google.c om>... > Hi, > > I wanted to know how can we send out email notification for the Jobs > that are completed. > > Thanks a lot in advance.... > > AJ You can set up SQL Mail, create an Operator to notify, and send an email on job success. Or execute a batch file when the job succeeds which calls an external email script. See Books Online for more information on SQL Mail and operators, and this link my be useful: http://support.microsoft.com/default...b;EN-US;263556 Simon |
Linear Mode
