Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I check my submit job is OK
select job, last_date, broken, next_date from user_jobs;
If your job is ok, broken will show 'N'. You can also check last_date to see when the job last run.
You should check next_date to see when the job will run again. Oracle tends to shift jobs by the time needed to execute the job.
It's a good practice to implement some additional logging (into some table) in the procedure executed by the job.
-- Giorgos "Trister " <jonathan_at_ms35.url.com.tw> wrote in message news:9e2ast$llj$1_at_news.seed.net.tw...Received on Fri May 18 2001 - 04:10:57 CDT
> Hi,all
> My DB is 8.0.6. I submited a job at PM10:00 every day.
>
> And my questio is How do I checked my submit job is Ok next day????
>
>