We post schedules for our trade contractors on our Intranet. When those schedules change we want to push an email out to the project manager to notify him of any changes made to the schedule. We would like to send out an email at 4:00am and at 4:00pm to notify the manager if there are or aren't any changes. All of the data is stored in a SQL 2000 database with SMTP already configured.
Could I do this in SQL, CDONTS, or ASPMail? Any direction would be greatly appreciated.
FYI - I already looked into creating a job notification within SQL but couldn't get it to work with my email variables.
This conversation is currently closed to new comments.
We need to send out multiple emails to multiple managers ONLY sending the schedule changes specific to him/her. Thus the email needs to be datadriven. We don't want to send an email with all of the schedule changes because some are for other non-related contractors.
It is possible as last person stated to use task scheduler, but you will need to direct task scheduler to run a windows script utilising CDONTS. This allows you to pull any info you need from your DB to generate into your mail.
Thanks. This is exactly what I ended up doing and it worked great. The windows script was written to query the DB and send the data out using CDONTS. The Task Scheduler was set to run the script every morning. The solution accomplished exactly what I wanted. It was also a simple solution - not too complex.
We have a product called X-Sheet, which is great for this type of custom solution, has powerfull scripting and reporting. I was just about to do a script example for emailing database reports. Read about X-Sheet at http://www.development-x.com you can download a trial. If you are interested in a sample post back a reply.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Sending scheduled emails
Could I do this in SQL, CDONTS, or ASPMail? Any direction would be greatly appreciated.
FYI - I already looked into creating a job notification within SQL but couldn't get it to work with my email variables.