Job Wont Run - Cant See Reason Why...

From: TimMcConechy <tjm_at_runtime.dk>
Date: 14 Apr 2003 06:55:52 -0700
Message-ID: <7afae186.0304140555.6841ad1e@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 - 08:55:52 CDT