Base oriented CRON
Andrey Lukichev asked whether Informix has an equivalent of Oracle's DBMS_JOB to schedule stored procedures inside the database. Christian Brauer suggested calling the procedures from shell scripts run by cron. Andrey replied he wanted a built-in feature for portability and compatibility. Jonathan Leffler argued that cron is the portable approach. No in-database scheduler was offered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, All! Sorry for may be stupid question, but in ORACLE i have DBMS_JOB package and can run stored procedures (jobs) dayly, weekly etc... Like CRON daemon in UNIX :) Is INFORMIX have this feature? Good Luck!
> can run stored procedures (jobs) dayly, weekly etc... Like CRON daemon in > UNIX :) > Is INFORMIX have this feature? What about calling your procedures from shell-scripts called by your CRON daemon ? Chris
Christian Brauer wrote in message <38465245.FECD0F8@Dresdner-Bank.com>... >> can run stored procedures (jobs) dayly, weekly etc... Like CRON daemon in >> UNIX :) >> Is INFORMIX have this feature? > >What about calling your procedures from shell-scripts called >by your CRON daemon ? Yes, thank you i know this way, but i really need something like DBMS_JOB in ORACLE - for portabylity and compat.
Andrey Lukichev wrote: > Christian Brauer wrote in message <38465245.FECD0F8@Dresdner-Bank.com>... > >> can run stored procedures (jobs) dayly, weekly etc... Like CRON daemon in > >> UNIX :) Is INFORMIX have this feature? > > > >What about calling your procedures from shell-scripts called > >by your CRON daemon ? > > Yes, thank you i know this way, but i really need something like DBMS_JOB in > ORACLE - for portabylity and compat. Well, we could argue that portability requires you to use cron and not the Oracle-specific way. In fact, I think I'm going to argue like that -- if portability is an issue, you use cron. Compatability is a separate bag'o'worms. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.62 -- see http://www.perl.com/CPAN #include <disclaimer.h>