Base oriented CRON

Posted in 1999

Andrey Lukichev — Thu, 2 Dec 1999 12:17:44 +0300 — source: Informix-list mailing list archive (1991-1998)

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!

↪ replying to Andrey Lukichev

Christian Brauer — Thu, 02 Dec 1999 12:04:37 +0100 — source: Informix-list mailing list archive (1991-1998)

> 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

↪ replying to Christian Brauer

Andrey Lukichev — Thu, 2 Dec 1999 18:34:20 +0300 — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Andrey Lukichev

Jonathan Leffler — Fri, 03 Dec 1999 05:34:21 -0800 — source: Informix-list mailing list archive (1991-1998)

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>