Re: dbms_job - makes my head spin

You may check if the job is broken or not. select what, job from user_jobs;

get job# from this query, then select broken,interval,failures from user_jobs where job=<job#>;
If B=Y, you have to rerun the job ==> maybe execute dbms_job.run(job#)?

Joan

Chiran Ghosh wrote:
>
> You may want to check the database alert logs for known errors.
>
> -----Original Message-----
> Sent: Wednesday, September 27, 2000 8:36 AM
> To: Multiple recipients of list ORACLE-L
>
> List,
> 8.1.5 (AIX)
> job_queue_processes = 1
> job_queue_interval = 10
>
> snp process is running , i checked..
>
> i have a simple stored procedure (tmp)which inserts a number into a table
> which i submitted as a job..
>
> dbms_job.submit(job_no,'tmp;',sysdate,'sysdate(1/1440');
> dbms_job.run(job_no);
>
> the interval is sysdate+1/1440 which calculates to 1 min.
>
> after i submit the job it runs once - baecuase of the dbms_job.run, but then
> fails to run at the 1 min. interval !!! the NEXT_TIME column IS updated
> every minute
> to reflect the new next_time but the FAILURES increase each time.
>
> what am i missing here...??
>
> Thanks
> Rahul
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Chiran Ghosh
> INET: Chiran.Ghosh_at_AlconLabs.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Sep 27 2000 - 09:55:13 CDT