Re: Scheduling Jobs in Postgres

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

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(at)mdtsoft(dot)com
<mailto:postmaster(at)mdtsoft(dot)com>.

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

On Tue, 18 Dec 2001, 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

cron is your friend.

A database is not the right place to do such a thing.

Gavin