i need to run jobs at predifned intervals of time and we have decided to automate this jobs i was wondering what to do use dbms_jobs package supplied by oracle or use cron and a shell script.
my task inculde
a)taking incremental exports
b)cleaning up archived log directory
c)other routine space administration tasks and paging them 2 a dba.
i am runing oracle 8.1.6 on redhat linux.source code or shell script examples to achieve the above tasks would be of great help.
thanks in advance
[Edited by hrishy on 02-22-2001 at 03:18 AM]
looking at the tasks ,I would go for cron jobs.
For A and B, Use Shell scripts.
For C, Use DBMS_JOB package.
Computer Software & Solutions,
Sultanate of Oman.
great answer folks but being new to this job ,wish somebody could provide me with the source code for doing this both for dbms_job and cron shell scripts i would be greatful.even websites would be great.
thanks for all the help
Click Here to Expand Forum to Full Width