February 14, 2008 at 1:23 am
Hi,
I have the table like
Id Pickuptime
1 2008-02-14 13:07:06.317
If 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
February 14, 2008 at 7:54 am
You can add a script task in SSIS and write a .net code for sending E-mail.
February 14, 2008 at 8:35 pm
Sounds like you may be able to utilize Notification Services to accomplish this.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
February 14, 2008 at 10:22 pm
Hi,
thank for the reply how to write the notification service would you please give me the guide.
regards
kumar
February 18, 2008 at 1:08 am
I know little about this topic, but isn't Notification Services canned in SQL Server 2008?
If so, you might have a problem if and when you decide to upgrade to a later version of SQL Server.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
February 18, 2008 at 8:22 am
That would be my concern. It's my understanding that it is being deprecated, but I have not seen anything formal on that.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply