Scheduled tasks - Mailing list pgsql-novice

From roy simkes
Subject Scheduled tasks
Date
Msg-id BAY108-W225CC88499E86DA529BFDA1890@phx.gbl
Whole thread Raw
Responses Re: Scheduled tasks  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-novice
Hi,
I know it has been asked a millions of times and I know there are previous posts about this topic too but the thing is I'm a windows user and I can't use cron. I'm sure that windows has it's own system like cron but what I look is something that is integrated to the pgsql. When the time will come he will do what he has to and will get to passive mod till the come once agan (yes, I know I describe cron.). Is there an option in pgsql that does this thing?
I think that there could be a way with triggers or functions. But this should slow down the server. I can insert this check in my forms but this will cause a higher slow down rate then triggers I think. Why do I need this is for a session table. I insert rows for logged in users. I delete them if they click logout. But if they dont I want that my session table be cleared from entries that are entered two days ago or something like that. As that session is an useless data and is just a junk in the db. And the scheduled task will check every 4.00 am or 5.00 am for junk entries and will delete them.
If there is no way for this in pgsql, how can I use, cron can you point me to a good tutorial or can you point me to the windows equal of the cron.
Thanks for your time.



Express yourself instantly with MSN Messenger! MSN Messenger

pgsql-novice by date:

Previous
From: Tom Allison
Date:
Subject: Re: iowait
Next
From: "Andrej Ricnik-Bay"
Date:
Subject: Re: Scheduled tasks