It appears to me that you do know how to use Windows scheduler, but you dnon't know how to write the program to read the database and send out e-mails.
One way to access mySql using Java is the use the
JDBC library. For a good basic tutorial on how to use JDBC, check out the JDBC chapter in a book called Just Java. If you want a more hands-on example, download and install the
mckoiDB database engine . It's free, small, and has some great sample code that should help you get up and running. 95% of the code that
you should need to complete the db-related portion of your program should be included with that application.
Now that you have the names, how are you going to e-mail them? Well, that has a lot to do with the e-mail application(s) that your company uses. There's a JavaMail library available, but it might not work in your system; check with your sysadmins to see what options are available.
Also, I wouldn't recommend creating a
JSP or
servlet to accomplish your tasks. A simple, standalone Java program with a public "main" method is your best choice.
HTH!
[ August 07, 2003: Message edited by: Tom Purl ]
