Re: Scheduling jobs

todd_at_cardinalgroup.com wrote:
>
> I am trying to schedule a job that will rebuild indexes every 15
> minutes or so. It appears that it is failing when I look at user_jobs
> for this scheduled job. I am able to run the job using execute
> dbms_job.run (job_num) but when I job is run normally, it fails. I can
> also run the stored procedure without incident. Any help would be much
> appreciated.
>

If you are on a UNIX system and really in a bind, just create a shell wrapper script and in the script you would invoke sqlplus and run the stored procedure. Once you have it working, just run it from the cron. Received on Thu May 18 2000 - 00:00:00 CDT