I am working on a project in which client will schedule that he want a perticular report to be mailed to him according to the schedule he set.
Lets take an example: Client schedules REPORT1 to be mailed to him after every week( lets say every monday)
I am maintaining a column in my SQL server 2000 database as 'Next_Runnung_Date' .
I have 2 optoins: 1. I will write a SQL job which will daily run and check the 'Next_Run_Date' column. If this matches the server current date then it should call the Java Class (But i dont know how can i call Java Class with parameter from SQL server 2000)
2. Write a Java Class (with threads) this thread will sleep for 24 hrs and after 24 hrs it will wake up and go to the database check the 'Next_running_date' column and accordingly call the other java class...... (But due to the thread ..it will affect my server performance...)
IS there any ohter way to do? is anybody of you have came across such situations before???
Look at Flux if you evaluate a set of commercial schedulers. They have persistent timers that reside in the database when you shut down and come back to life when you start up again. Oh, wait, that may be our application doing that.
If I am not mistaken a Java program can be converted to exe. There are some utilities I believe at download.com. So if I write a program and then schedule it through the windows schedular is there a problem ?