Home > Archive > Microsoft SQL Server forum > June 2005 > SQL Agent Mail Notifications









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author SQL Agent Mail Notifications
Gary

2005-06-28, 7:23 am

Assistance Please

I have a couple of scheduled jobs that are failing to e-mail
notifications on completion (via SQL Agent Mail).

I can send a Test e-mail without any problems. I can run the jobs
manually, and the e-mail notification works effectively.

Left to run according to the schedule, and no e-mail notification is
generated.

Any assistance greatly appreciated.

Thanks



*** Sent via Developersdex http://www.droptable.com ***
christopher.secord@gmail.com

2005-06-30, 11:23 am

> I have a couple of scheduled jobs that are failing to e-mail
> notifications on completion (via SQL Agent Mail).


Could it be that the SQLAgent user doesn't have permission to send
email? If you can log in as that user, try doing so and then running
the job.

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com