Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhani
Posting Yak Master
132 Posts |
 Posted - 2009-03-18 : 11:51:23
|
| Hello All,i am using Sql Server 2005,in my Sql Server Agent, i have some jobs (developed in SSIS )now i would like to setup email notification to my mail id (outlook mail id) please consider these below--> i am new to this sql server agent usage--> this is my first time setting up email notification i tried in inline solutions (oh my god different different solutions some relate to procedure based, like so...)now what i am requesting you is, tell me how can i set up email accounts (outlook or even some gmail accounts... etc) when job fails (this jobs were ususallu scheduled daily and some are weekly)please help meBest Regardsdhani |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-03-18 : 12:58:17
|
| Hello;If you wish to schedule an email to be sent to you when sql agent fails then you need to setup a mail profile and also setup the notification in sql agent. These are very simple to do.Using SSMS (SQL Server Management Studio): Go to the Management --> Database Mail icon and click it. This will guide you through the steps of creating a mail profile that SSMS will use when sending emails.NextGo to SQL Server Agent --> JobsClick open the scheduled job that you are interested in. Examine both the ALERTS and NOTIFICATIONS properties. These will allow you to setup whatever email notices you want.r&r |
 |
|
|
|
|
|
How to get email ,when job fails in sql job agent