Page 1 of 1

require recommendation for database job scheduling

Posted: Wed Dec 03, 2008 3:37 am
by tweakmy
Hi to all,
As mentioned on the top, I would like to able to set/reset/edit data scheduling via php for an oracle database.

ETC:
every day at 00:00:00
select * from table1 where A=100 and date > SYSDATE -1

the output could be a csv format for example.

How would you do it?

Re: require recommendation for database job scheduling

Posted: Wed Dec 03, 2008 3:58 am
by jaoudestudios
You would have to use a cron job on the linux server.

Re: require recommendation for database job scheduling

Posted: Wed Dec 03, 2008 4:10 am
by tweakmy
jaoudestudios wrote:You would have to use a cron job on the linux server.

ok, i do know bout the cronjob, in fact you could use "at".

Can you detailed it out? How do you finally export it as csv?