August 26, 2009 at 9:24 am
Hello SQL DBA Experts..
Today I have created a couple of jobs in the Maintenance Plans(e.g, Rebuild Index, Shrink DB, Update Stats..) and executed the same and found that running absolutely fine! 🙂
But I wanted to go one step more by configuring the Alerts and Notifications.
I tried by myself and set up the Notification so that for the failures I will be notified. I intentionally failed one job to see whether the "notification" is working. But no, it is not. I chose my personal email id: 'sourav.techmail@gmail.com'.
Can anyone of you share any good article with me to configure the "alerts" and "notifications" to help in automating the jobs please?
Will look forward to listen from you.
Thank you
Regards
Sourav
Thanks.
August 26, 2009 at 10:25 am
If you have configured database mail already, you may just need to enable SQL Server Agent to use database mail.
Right click SQL Server Agent from SQL Server Management Studuio and select Properties.
Select the Alert System Page and then check "Enable mail profile" and select your database mail system and profile. The mail system should be "Database Mail" and the profile will be whatever you configured for database mail. Then restart SQL Server Agent and you should be good to go.
August 26, 2009 at 1:00 pm
Hello,
Could you please send me the steps to configure database mail please? I'm trying the same at my home and do not have any seperate domain!
Regards
Sourav
Thanks.
August 26, 2009 at 8:27 pm
Hello there,
You can try the following steps.
1. Change Log On information of MSSQLServer from Windows Services.
2. Also change Log On information of SQLServerAgent from Windows
Services.
To do 1 & 2 go to Windows Services window, select MSSQLSERVER and
SQLSERVERAGENT services one by one. Select Log On tab. Select "This
Account" option button instead of "Local System Account" option button.
And put domain user acount and password as domain\userid. Domain must
be the same to which you were logged in. And lastly restart the services.
3. Then configure Profile information. To do this explore Control
Panel. Click on Profile icon. Remove the added email account
information and then add it again.
4. Now open Enterprise Manager of SQL and go to Database Server
Properties window. Selected Server Setting tab. Click on Change button
in area SQL Main and select the profile from the combo.
5. Now go to SQL SErver Agent's propeties window and select the
prfile name in Mail Session area.
6. Again restart MSSQLSERVER, SQLSERVERAGENT, Performance Log and
Alerter services from Windows Services window.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply