[GENERAL] How to write jobs in postgresql

2005-08-04 Thread chiranjeevi.i
Hi Team Members,       Is it possible to write jobs in postgresql & if possible how should I write .please help me.       Cheers, --- Chiranjeevi Illa Member - Software Development Team PyroNetworks Pvt Ltd.,    

Re: [GENERAL] How to write jobs in postgresql

2005-08-05 Thread Michael Fuhr
On Wed, Aug 03, 2005 at 09:08:48AM +0530, chiranjeevi.i wrote: > Is it possible to write jobs in postgresql & if possible how should I > write .please help me. Please explain what you mean by "job." What are you trying to do? -- Michael Fuhr ---(end of broadcast)---

Re: [GENERAL] How to write jobs in postgresql

2005-08-05 Thread Michael Fuhr
[Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Fri, Aug 05, 2005 at 06:28:04PM +0530, chiranjeevi.i wrote: > I have to dump up my database into a text file(using copy) at 2 am on every > day. And from that I have to get the database details.

Re: [GENERAL] How to write jobs in postgresql

2005-08-05 Thread Douglas McNaught
"chiranjeevi.i" <[EMAIL PROTECTED]> writes: > Is it possible to write jobs in postgresql & if possible how should I > write .please help me. What does "write jobs" mean? -Doug ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner w

Re: [GENERAL] How to write jobs in postgresql

2005-08-05 Thread Bricklen Anderson
Douglas McNaught wrote: >> Is it possible to write jobs in postgresql & if possible how should I >>write .please help me. > > > What does "write jobs" mean? > I'm assuming this person has an Oracle background, if so, jobs are Oracle's equivalent to a built-in cron scheduler. This has been disc

Re: [GENERAL] How to write jobs in postgresql

2005-08-08 Thread Chris Browne
[EMAIL PROTECTED] ("chiranjeevi.i") writes: >     Is it possible to write jobs in postgresql & if possible how > should I write .please help me.:p> What do you mean by "job?" If you mean "run some sort of scheduled script," then that represents something that you could do using your favorite oper

Re: [GENERAL] How to write jobs in postgresql

2005-08-09 Thread Guy Rouillier
chiranjeevi.i wrote: > Hi Team Members, > > Is it possible to write jobs in postgresql & if possible how > should I write .please help me. See pgjob in pgfoundry: http://pgfoundry.org/projects/pgjob/. It's in the planning stages. -- Guy Rouillier ---(end of broadc

Re: [GENERAL] How to write jobs in postgresql

2005-08-15 Thread Jim C. Nasby
On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote: > chiranjeevi.i wrote: > > Hi Team Members, > > > > Is it possible to write jobs in postgresql & if possible how > > should I write .please help me. > > See pgjob in pgfoundry: http://pgfoundry.org/projects/pgjob/. It's in > the

Re: [GENERAL] How to write jobs in postgresql

2005-09-06 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500: > On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote: > > chiranjeevi.i wrote: > > > Hi Team Members, > > > > > > Is it possible to write jobs in postgresql & if possible how > > > should I write .please help me. > > > > See pgjob i

Re: [GENERAL] How to write jobs in postgresql

2005-09-06 Thread Guy Rouillier
Roman Neuhauser wrote: > # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500: >> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote: >>> chiranjeevi.i wrote: Hi Team Members, Is it possible to write jobs in postgresql & if possible how should I write .please help me.

Re: [GENERAL] How to write jobs in postgresql

2005-09-06 Thread Jim C. Nasby
On Tue, Sep 06, 2005 at 04:29:31PM -0500, Guy Rouillier wrote: > Roman Neuhauser wrote: > > # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500: > >> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote: > >>> chiranjeevi.i wrote: > Hi Team Members, > > Is it possible to wr

Re: [GENERAL] How to write jobs in postgresql

2005-09-06 Thread Chris Browne
[EMAIL PROTECTED] (Roman Neuhauser) writes: > # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500: >> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote: >> > chiranjeevi.i wrote: >> > > Hi Team Members, >> > > >> > > Is it possible to write jobs in postgresql & if possible how >> > > s

Re: [GENERAL] How to write jobs in postgresql

2005-09-08 Thread Karsten Hilbert
> 3. An integrated way of logging what ran when (rather than either > stuffing logging code into each cron job or rummaging thru > cron logs) Cron can log to syslog. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 --

Re: [GENERAL] How to write jobs in postgresql

2005-09-08 Thread Chris Travers
Karsten Hilbert wrote: 3. An integrated way of logging what ran when (rather than either stuffing logging code into each cron job or rummaging thru cron logs) Cron can log to syslog. Karsten And your cron scripts could log to your database log tables if that is what you were

Re: [GENERAL] How to write jobs in postgresql

2005-09-09 Thread Jim C. Nasby
On Thu, Sep 08, 2005 at 10:27:59AM -0700, Chris Travers wrote: > Karsten Hilbert wrote: > > >>3. An integrated way of logging what ran when (rather than either > >>stuffing logging code into each cron job or rummaging thru > >>cron logs) > >> > >> > >Cron can log to syslog. > > > >Kars