SQL Server Agent Notifications

[cobdeng]

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

 

[DrSql]

Create a new job and try to execute this job.
Make sure change @to and @server

exec @rc = master.dbo.xp_smtp_sendmail
@FROM = N'alerts@tek-tips.com',
@FROM_NAME = N'Admin',
@TO = N'yourname@domain.com,
@subject = N'Email Test',
@message = N'Email Test was sucessful',
@type = N'text/plain'
@server = N'exchangeservername.com'
select RC = @rc

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[Catadmin]

Question. When you're not logged into the server, what username / permissions is the job auto running under? What about the SQL Server Service account and the SQL Server Agent account? Are they using a local machine admin account or a domain user account?

Also, go into the SQL Server Agent -> Jobs folder, right click your job and look at the owner name under the General Tab. If it's under your name, try changing the owner to SA and see if you get the notifications during the scheduled run once the owner has been changed.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???