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 |
|
tm555
Starting Member
5 Posts |
 Posted - 2008-02-14 : 05:38:51
|
| Hi, I have the table likeId Pickuptime 1 2008-02-14 13:07:06.317If the record is inserted to the above table that would look at a pickuptime field in a table and if pickuptime is 2008-02-14 13:07:06.317 after 6 hour from the pickuptime then I would send a email to briteindia_kumar@hotmail.com How i would do this would any one help to me. Thanks kumar |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-02-14 : 05:43:01
|
| Create a DTS Package and use Send mail task. |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-14 : 06:09:29
|
| Or else, in the DTS package, you can use ActiveX script task and make use of CDO.Message object and send mail using that.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
sending database mail