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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2008-08-04 : 23:32:09
|
| GurusWhen we create a job in Sql Server 2005 we have a option in properties table,where we can setup a alert by email ,whenever a job fails.Is this email enabled by using sql mail?Do we need to have that configured?My requirement is that i should receive a mail wheneve my job failsThanksNitin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-04 : 23:35:33
|
| Better to use db mail in sql2k5, you need config db mail first. |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-08-04 : 23:41:24
|
| Thanks for the reply,did you meant that alerts will not work untill in configure DB mail in 2005?Do we have any other option?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-04 : 23:47:55
|
| Alert by mail will not work. By the way, sql mail needs pop3 mail server while db mail uses smtp mail server. |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-08-04 : 23:49:37
|
| Thanks a Lot |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2008-08-07 : 04:33:29
|
| GurusCant we use send mail task in SSIS? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-07 : 08:09:39
|
| you can . |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 22:52:56
|
| >> Cant we use send mail task in SSIS?For sql job notification or in general? |
|
|
|
|
|
|
Alert when job fails