November 28, 2012 at 8:06 am
Have a job for disc space alerts but its failing since 2 days with the following error.
Executed as user: SQL Server blocked access to procedure 'sys.xp_sendmail' of component 'SQL Mail XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'SQL Mail XPs' by using sp_configure. For more information about enabling 'SQL Mail XPs', see "Surface Area Configuration" in SQL Server Books Online. [SQLSTATE 42000] (Error 15281). The step failed.
My "Database Mail Xps" is already enabled.
November 28, 2012 at 8:23 am
So what happens when you try to send a test mail from Database Mail? Does it arrive? Does your job include an explicit sp_send_dbmail or is it just the notification that's failing once the job has executed?
John
November 28, 2012 at 8:30 am
Yes I am able to send test email.
The job is executing --exec dbo.User_SP_DiskFreeSpaceAlert
November 28, 2012 at 8:33 am
And what does that stored procedure do? Does it attempt to send an e-mail? Do you receive the e-mail if you execute the stored procedure outside of the job? Do you have a notification set up on the job that's failing?
John
November 28, 2012 at 8:41 am
No there are no notifications. We did not setup any email notification for that
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply