Thread: Scheduled tasks
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
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
On 6/10/06, roy simkes <roysimkes@hotmail.com> wrote: The windows equivalent to cron would have to be "scheduled tasks" (it's been a while that I last used that ;} ... 4 years or so). Cheers, Andrej
The Windows command is 'at'. keith Andrej Ricnik-Bay wrote: > On 6/10/06, roy simkes <roysimkes@hotmail.com> wrote: > The windows equivalent to cron would have to be "scheduled tasks" > (it's been a while that I last used that ;} ... 4 years or so). > > > Cheers, > Andrej > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- "Every magnificent history begins with something small." Daisaku Ikeda ======================================================= Keith D. Evans Joint Center for Earth Systems Technology/UMBC (301) 614-6282 (M,Tu) (410) 455-5751 (W,Th,F) http://www.jcet.umbc.edu/bios/evanmain.html ======================================================== Any opinions expressed in this email are not those of NASA, or the Goddard Space Flight Center, or the Joint Center for Earth Systems Technology or the University of Maryland Baltimore County. ========================================================
Keith D. Evans wrote: > The Windows command is 'at'. > keith > > > Andrej Ricnik-Bay wrote: > >> On 6/10/06, roy simkes <roysimkes@hotmail.com> wrote: >> The windows equivalent to cron would have to be "scheduled tasks" >> (it's been a while that I last used that ;} ... 4 years or so). >> >> >> Cheers, >> Andrej >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> > > "at" is the older version the Scheduled Tasks. In 2k/XP Scheduled tasks gives more options than AT and a GUI to manage the whole thing. The AT commands show up in the Scheduled tasks as well but have non intuitive names etc. Oisin