Equivalent to DBMS_JOB

[Arturo Pérez]

Oracle has a kind of cron built-in called DBMS_JOB. You can use
it to run SQL or stored procedures at certain times of day, etc.

Does postgreSQL offer anything similar? And please don't
say use cron. Cron has issues that I'd like to avoid.

Just curious, nothing more. It would be helpful but it's not
worth a flamefest over cron versus a built-in.

Thanks in advance.

[Peter Eisentraut]

Arturo Pérez writes:

Does postgreSQL offer anything similar?
No, we tell people to use cron.
And please don't say use cron. Cron has issues that I'd like to avoid.

Too bad.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[David Fetter]

Arturo Pérez <fr**@noplace.org> wrote:

Oracle has a kind of cron built-in called DBMS_JOB. You can use it
to run SQL or stored procedures at certain times of day, etc.

Does postgreSQL offer anything similar? And please don't say use
cron.
Why not?
Cron has issues that I'd like to avoid.

What issues are those? Please be specific.

Cheers,
David.
--
David Fetter da***@fetter.org http://fetter.org/
phone: [phone] cell: [phone]

The laissez-faire argument relies on the same tacit appeal to
perfection as does communism.
George Soros

[Alvaro Herrera]

On Sun, Nov 30, 2003 at 12:19:34AM -0500, Arturo Pérez wrote:

Does postgreSQL offer anything similar? And please don't
say use cron. Cron has issues that I'd like to avoid.

Huh, just curious: what issues does cron have?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[Christopher Browne]

Martha Stewart called it a Good Thing when al******@dcc.uchile.cl (Alvaro Herrera) wrote:

On Sun, Nov 30, 2003 at 12:19:34AM -0500, Arturo Pérez wrote:

Does postgreSQL offer anything similar? And please don't
say use cron. Cron has issues that I'd like to avoid.

Huh, just curious: what issues does cron have?

It does have the demerit that it isn't terribly "transactional." And
the tools for managing jobs are likewise not much transactional.
--
let name="cbbrowne" and tld="ntlug.org" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/spiritual.html
Rules of the Evil Overlord #35. "I will not grow a goatee. In the old
days they made you look diabolic. Now they just make you look like a
disaffected member of Generation X." <http://www.eviloverlord.com/>

[Tino Wildenhain]

Hi,

Christopher Browne schrieb:
[...]

It does have the demerit that it isn't terribly "transactional." And
the tools for managing jobs are likewise not much transactional.

Are they not? May bit its not perfect with many concurrent
changes in a short period of time but in "normal" usage
its transactional enough. You can write a little script
with a non restricted language to access postgres
users cron tab from within SQL if you like. Should not
be so hard and an easy way to contribute :-)

Regards
Tino Wildenhain
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org