Re: Job Wont Run - Cant See Reason Why...

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Mon, 14 Apr 2003 16:02:17 +0200
Message-ID: <b7eeug$ssm$1@news.mch.sbs.de>

You need to issue a commit!

Stephan

"TimMcConechy" <tjm_at_runtime.dk> wrote in message news:7afae186.0304140555.6841ad1e_at_posting.google.com...
> I wrote some code to make it easier to submit a job...
> lFunction:='WorkFlow.AutoSend();';
>
> select AutoSend,AutoSendTime into lAutoSend,lAutoSendTime from
> WORKFLOW_CONFIG;
> IF lAutoSend=1 THEN
> --find the job id...
> for x in (select job from dba_jobs where what=lFunction)
> loop
> --if found delete it
> DBMS_JOB.REMOVE(x.job);
> end loop;
> --submit the job under the new timing factor..
> DBMS_JOB.SUBMIT(jobid,lFunction,SYSDATE , 'SYSDATE +
> '||to_char(lAutoSendTime)||'/1440');
> END IF;
>
> This seems to work ok...When I look in DBA_JOBS I see that everything
> appears ok..
> SQL> SELECT JOB, SUBSTR(WHAT,1,35), NEXT_DATE,BROKEN,INTERVAL FROM
> DBA_JOBS;
>
> JOB SUBSTR(WHAT,1,35) NEXT_DATE B
> ---------- ----------------------------------- --------- -
> INTERVAL
> --------------------------------------------------------------------------

---

> 5 WorkFlow.AutoSend(); 14/APR/03 N
> SYSDATE + 1/1440
>
>
> But the job simply will not run...If I call..
> dbms_job.run(5);
> Then it runs but otherwsie not. The failures column is at 0 and the
> broken column is at N also last_date,last_sec is never updated....
>
> BR
> Tim
Received on Mon Apr 14 2003 - 09:02:17 CDT