Notify Operator Task

[snootalope]

Hello

First of all, I'm very new to SQL so I appologize for anything that sounds off.. I've spent the last few hours going through online help documentation trying to figure this out...can't get it.

I've setup a maintence plan to backup our transaction log hourly. That works just fine. I'm trying to modify the plan though and use the Notify Operator Task to send me an email if something goes wrong.

I've setup myself as an operator and filled out the appropriate info in my operator account. I go in and modify the transaction log plan by adding the Notify task and selecting myself to be notified. Oh, and I drag the little green arrow from the Plan box to the Notify box...

Once I run the job via the Job Monitor screen, I get this:

Date 11/2/2006 9:03:00 AM
Log Job History (TransactionLog)

Step ID 1
Server SQLSERV\IMG
Job Name TransactionLog
Step Name Subplan
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: DOMAIN\Admin. The package execution failed. The step failed.

I've googled that error, as well as looked it up on the MS technet site. I'm guessing its such a simple configuration error on my part that it's not even listed out there!

Can someone please lend me some advice?
thanks!

 

[sqlcasey]

Did you set up database mail? Have you sent yourself a test email? That would be the first step.

I just did this yesterday, the steps are (in sql server 2005 anyways): It may be totally different in previous versions.

1.) set up database mail using the database mail wizard, have your smtp account info handy

2.) set up your operator

3.) add the notification to the job, on success or failure

4.) restart sql agent if needed

 

[snootalope]

yep, just figured that out myself.. Rather then adding the Notify Operator Task to the job details, I just added it to the notification section of the scheduled job. Works just fine.

thanks!