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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 e-mail

Author  Topic 

Jack_Oh
Starting Member

7 Posts

Posted - 2010-11-13 : 18:00:11
I was wanting to automate at specified times a process that goes out and executes a stored procedure that check a table to see which records contain a date column that falls within a time period, gets those records and then calls a function in vb.net to send out emails to users in the records that fit the specified criteria in the stored procedure to receive an email. Thanks In Advance for any recommendations or suggestions.

Ronald Rex

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2010-11-15 : 05:19:03
I would be tempted to look at this as an application problem, i.e. write an app that makes the sproc call at specific times and then emails the results.

-----------

I used to think I wasn't a morning person but it never got better in the afternoon
Go to Top of Page
   

- Advertisement -