November 23, 2009 at 4:46 am
Is it possible to get an email after a backup get completed in sql server 2005 ? If so , Pl guide me how to do that.....
Thanks in Advance
Regards,
Manickam
November 23, 2009 at 6:00 am
Hi Sundar,
If you are using the SQL Server 2005 Enterprise version, you can setuo the email feature. Please go through the URL as it has very good step by step explaination for email setup.
November 23, 2009 at 6:28 am
Read this for Job notification email setup.
http://support.microsoft.com/kb/908360
To set up SQL Server Agent Mail to use Database Mail
In Object Explorer, expand a server.
Right-click SQL Server Agent, and then click Properties.
Click Alert System.
Select Enable Mail Profile.
In the Mail system list, select Database Mail.
In the Mail profile list, select a mail profile for Database Mail.
Restart SQL Server Agent.
Then you need to select the Profile for SQL Server.
To set the mail profile for SQL Server Agent
In the Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
Right-click SQL Server Agent, and then click Properties.
On the Alert System page, check Enable Mail Profile.
If the Enable Mail Profile checkbox is not available, SQL Mail or Database Mail is not configured properly.
Select either Database Mail or SQL Mail from the Mail system list. If you choose SQL Mail, select a profile in the Mail profile box. If no profiles are listed, enter the name of the profile to use.
Restart the SQL Server Agent service for your changes to take effect.
November 23, 2009 at 6:51 am
Database Mail should work in all editions except Compact and Express.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply