I have been asked to set up an automatic email that will send a text message to a group of managers each night with the current day’s production and the next day’s projected production.
The reporting app I built already contains this information and the database updates the info each night through a couple of jobs. The record sets that return the results execute stored procedures to obtain the data.
The MSSQL Server 2000 is not set up for MAPI. Our network does use MS Exchange server.
I realize that there is a wealth of information concerning this subject, but, I am overwhelmed and don't know which method to implore. What is your opinion on how to tackle this request?
Thanks in advance for the advice.
Kind regards,
Krickles
The reporting app I built already contains this information and the database updates the info each night through a couple of jobs. The record sets that return the results execute stored procedures to obtain the data.
The MSSQL Server 2000 is not set up for MAPI. Our network does use MS Exchange server.
I realize that there is a wealth of information concerning this subject, but, I am overwhelmed and don't know which method to implore. What is your opinion on how to tackle this request?
Thanks in advance for the advice.
Kind regards,
Krickles
object in your ASP code to send your email. You can use windows scheduler to run your asp file periodically for exampe, 11:00pm. Any further help needed, let me know.