Re: Scheduling Jobs in Postgres - Mailing list pgsql-hackers

From pwd@mdtsoft.com
Subject Re: Scheduling Jobs in Postgres
Date
Msg-id 200112181132.fBIBWhO27028@mdtsoft.com
Whole thread Raw
In response to Scheduling Jobs in Postgres  (Jayaraj Oorath <jayoorath@yahoo.com>)
List pgsql-hackers
What you want first is a scirpt or program to do the job
that you are trying to do, I would write it in perl but 
python, c or even shell is also fine.

the program should be able to do the job without output 
to the screen (sdtout or stderr) UNLESS something does
not work (and even then it is best if it sends mail on
error as well (to you).

then just have the program above run by cron.

this is not a postgresql answer, the same woud be true
for any data base or other system on unix (I have assumed
that you are not running on Windows).

On 18 Dec, Jayaraj Oorath wrote:
> Hi,
> 
> I am a new to Postgres. I have a problem. I want to
> schedule some jobs at a particular time on a
> particular day of a week. To make it more clear, my
> requirement is to send mails to people based on the
> availability of data in some fields once in every
> week. How do I go about doing this ???
> 
> Can any one help me on this??
> 
> Regards,
> 
> Jay Oorath
> 
> Bangalore
> 
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

-- 
It is MDT, Inc's policy to delete mail containing unsolicited file attachments.
Please be sure to contact the MDT staff member BEFORE sending an e-mail with
any file attachments; they will be able to arrange for the files to be received.

This email, and any files transmitted with it, is confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error, please advise postmaster@mdtsoft.com
<mailto:postmaster@mdtsoft.com>.

Philip W. Dalrymple III <pwd@mdtsoft.com>
MDT Software - The Change Management Company
+1 678 297 1001
Fax +1 678 297 1003




pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Problem compiling postgres sql --with-tcl
Next
From: mlw
Date:
Subject: Re: Connection Pooling, a year later