cron works pretty well in unix. Scheduled tasks on windows have, in my
experience, been on the flakey side.
On Tue, 7 Dec 2004, [iso-8859-2] Együd Csaba wrote:
> Hi,
> I should schedule the execution of several stored procedures. Now I use an
> NT service for this, but as far as I know e.g. the Oracle has such a thing.
> It would be great if I could fire procedures on a timer basis.
>
> Is there a better solution for this than mine?
>
> Many thanks,
>
> -- Csaba
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 2004.12.03.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@no-spam
The world rejoiced as csegyud@no-spam (Együd Csaba) wrote:
> Hi, I should schedule the execution of several stored
> procedures. Now I use an NT service for this, but as far as I know
> e.g. the Oracle has such a thing. It would be great if I could fire
> procedures on a timer basis.
>
> Is there a better solution for this than mine?
Traditionally, PostgreSQL has consciously omitted such things where
they would merely be replicating existing operating system
functionality.
On Unix, "cron" is the traditional service that provides this
functionality.
I think there's a port to Windows NT, so you could presumably use that
if you haven't got any more "native" job scheduler.
--
output = reverse("moc.liamg" "@no-spam" "enworbbc")
http://www.ntlug.org/~cbbrowne/lsf.html
"How should I know if it works? That's what beta testers are for. I
only coded it." (Attributed to Linus Torvalds, somewhere in a
posting)
On Tue, 2004-12-14 at 07:49, Christopher Browne wrote:
> Traditionally, PostgreSQL has consciously omitted such things where
> they would merely be replicating existing operating system
> functionality.
>
> On Unix, "cron" is the traditional service that provides this
> functionality.
>
> I think there's a port to Windows NT, so you could presumably use that
> if you haven't got any more "native" job scheduler.
I haven't administered a Winbox in a few years, but I remember wincron
being quite good back in the day. It's free, but registration gets you
support.
http://www.wincron.com/index.html
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@no-spam so that your
message can get through to the mailing list cleanly