I have configured the Database Mail, and the test email is successful. I have to also use this database Mail profile and build the SQL Server Agent job called Automated Email. When the job run, I want the email to be sent to the administrators that backup job was successsful and it should include all the files created in the backup process. So in the job command the code is as the following: The job runs successfully but when I add the following parameter @file_attachment = 'C:\Program Files\Microsoft SQL Server.....error the Access denied. What is the right way to work on that, how do I cross this hurdle. I am using sqlserver 2005.
Use msdb GO EXEC sp_send_dbmail @profile_name ='DB Mail Profile', @recipients ='csaha@imsa.edu', @copy_recipients ='csaha@imsa.edu', @blind_copy_recipients='csaha@imsa.edu', @body ='This is a test message', @subject='Database Backup', @body_format='TEXT', @importance='Normal', @sensitivity='Normal'
Chitra
