Automate a script

[tls]

Hi,
Im new to Oracle and I have a big problem. I want to run a script (Oracle 8i) daily at a given time. please let me know how to schedule it. thanks in advance

[robertbalmer]

1. Create a procedure for your scl script
2. Create a job defining you procedure in the job
3. Execute job and test
3. go to Orahome\rdbms\admin\spauto.sql to get an example of script for a
job

[dbasan]

Hi,
Im new to Oracle and I have a big problem. I want to run a script (Oracle 8i) daily at a given time. please let me know how to schedule it. thanks in advance

1. If you are running windows then use at jobs to schedule to run the batch file where you have the scripts as SQL file inside the batch file.

2. you can also use scheduled task under control panel to schedule.

2. You can schedule the jobs using the OEM gui tool jobs.

3. If you are using Unix use cron to automate

[KenEwald]

tls,

You have many options. Those suggested above are excellent choices. Here are some things to keep in mind.

Some job schedulers may not know about downtime (scheduled or otherwise).

Document your jobs. Include dependency information.

Review jobs regularly. Put a reminder on your calendar to go through them to do a "do we really need this job" sanity check.

To minimize points of failure, you might want to keep the job scheduler close to the operating system (at/cron).

-Ken