require recommendation for database job scheduling

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tweakmy
Forum Newbie
Posts: 2
Joined: Wed Dec 03, 2008 3:24 am

require recommendation for database job scheduling

Post 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?
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: require recommendation for database job scheduling

Post by jaoudestudios »

You would have to use a cron job on the linux server.
tweakmy
Forum Newbie
Posts: 2
Joined: Wed Dec 03, 2008 3:24 am

Re: require recommendation for database job scheduling

Post 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?
Post Reply