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?
require recommendation for database job scheduling
Moderator: General Moderators
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: require recommendation for database job scheduling
You would have to use a cron job on the linux server.
Re: require recommendation for database job scheduling
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?