Tony Davidson
asked on
SQL 2005 Maintenance Plan E-mail fails
Hello,
I have setup a maintenance plan using these instructions http://www.techrepublic.com/blog/the-enterprise-cloud/create-database-maintenance-plans-in-sql-server-2005-using-ssis/#.
The backup works fine, however the e-mail notification fails with -1073548784
Would appreciate advice on how to troubleshoot
I have setup a maintenance plan using these instructions http://www.techrepublic.com/blog/the-enterprise-cloud/create-database-maintenance-plans-in-sql-server-2005-using-ssis/#.
The backup works fine, however the e-mail notification fails with -1073548784
Would appreciate advice on how to troubleshoot
ASKER
Hello sjwales
Mail Config was done, SQL Agent was not configured to use Database Mail, so hopefully when the job runs tonight I will receive an e-mail.
I'll update this question tomorrow.
Thank you.
Mail Config was done, SQL Agent was not configured to use Database Mail, so hopefully when the job runs tonight I will receive an e-mail.
I'll update this question tomorrow.
Thank you.
ASKER
No change, same error as before.
This is not entirely surprising to me, because the instructions that I followed did not mention the need to configure the SQL Agent.
This is not entirely surprising to me, because the instructions that I followed did not mention the need to configure the SQL Agent.
How have you set up the notification ? To notify an operator ?
If so is the operator set up ?
Does email work at all ? Have you tried just calling sp_send_dbmail and seeing if that works ?
If so is the operator set up ?
Does email work at all ? Have you tried just calling sp_send_dbmail and seeing if that works ?
ASKER
I don't know the answer to your first two questions. What I have done is follow the instructions in the link in my question.
E-mail does work. And by that I mean that I have run the Database Mail Configuration Wizard, created a profile and an account. Using Database Mail I can send a test e-mail to myself.
E-mail does work. And by that I mean that I have run the Database Mail Configuration Wizard, created a profile and an account. Using Database Mail I can send a test e-mail to myself.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
No.
An Operator was not defined, as that was not in the instructions that I was following.
I have created an Operator and gone back to the job and configured the notification. It looks like those instructions I were following were a crock regarding the notification.
I'll update you tomorrow.
Thanks
An Operator was not defined, as that was not in the instructions that I was following.
I have created an Operator and gone back to the job and configured the notification. It looks like those instructions I were following were a crock regarding the notification.
I'll update you tomorrow.
Thanks
Concepts:
http://technet.microsoft.com/en-us/library/ms175887%28v=sql.90%29.aspx
The Database Mail Config Wizard:
http://technet.microsoft.com/en-us/library/ms175951%28v=sql.90%29.aspx
If you haven't done the above, Database Mail won't work.
Once that's done, have you setup your Agent job to use Database Mail ?
http://technet.microsoft.com/en-us/library/ms186358%28v=sql.90%29.aspx
That would be the first two things to look at.