Hi

I'm having a problem using xp_sendmail as part of a scheduled job.

The actual stored procedure is being called from within a DTS package. When
the package is executed manually, everything works OK and the mail is sent.

If however the package is scheduled to run as a job, no mail is sent out to
the recipients. What's really funny is that the job appears to complete
successfully and no error messages are displayed, but the mail just doesn't 
seem to get sent.

Can anyone please assist?
Regards

Marcell

That should not be a problem. Just try executing again.
If it doesnt work just restart the instance and check again. These kind
of things do happen

Also check for the user who is running the automated process? hope that
user has permissions to send the mail

best Regards,
Chandra
http://chanduas.blogspot.com/
---------------------------------------

best Regards,
Chandra
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

Is sql server and the job scheduler running as the same user?

Show quoteHide quote

The server encountered a stack overflow during compile time.
SP4 reports queries blocking on themselves?
Return a horizontal table for result
comparing text fields - Second try
byte manipulation for int