> > I can't understand the objection. The only think that I do see here > are objections without explaining why. Why such type of features will > be bad ? > Why time based data manipulation are not good for databases but should > be external ? > Don't get me wrong, if I'll understand why, I will write that I was > wrong, but I opened this for a discussion and the only thing I read > here, is the word "No", and not "why not".
The feature you are talking about is a part of the large enterprise-scale job scheduling systems that span different hosts, operating systems and applications. Such systems support the time scheduled jobs including the ones you described, but also they support job dependencies, conditional execution branches based on return codes, etc. They cost a lot, but they do their job very well. We use one of such systems in a bank to control all batch jobs during the night. But I also object to include it into Firebird. You took only part of the requirements that exist for such systems. Even if we add the code you ask for to Firebird, your wish-list will become larger and at the end will include the features I described above. Finally we will get something that tries to do everything but is not able to do anything right. If you take a big picture, the only viable answer to the job scheduling problem is to have a set of command line scripts that do your tasks. That is how it is implemented by the commercial vendors (and they have spent enough money to find the best solution). In your case, you can have an universal command line script that invokes the stored procedure or executes SQL block specified in the command line. Then you have to choose the job scheduling tool that fits your needs. That can be cron, if that is not enough, take Quartz (Java-based scalable job scheduler that supports your requirements), if that is not enough - buy something from HP, CA or Cisco. Roman ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
