By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,660 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,660 IT Pros & Developers. It's quick & easy.

Equivalent to DBMS_JOB

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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)

Nov 12 '05 #2

P: n/a
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: +1 510 893 6100 cell: +1 415 235 3778

The laissez-faire argument relies on the same tacit appeal to
perfection as does communism.
George Soros
Nov 12 '05 #3

P: n/a
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

Nov 12 '05 #4

P: n/a
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/>
Nov 12 '05 #5

P: n/a
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

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.