TimMcConechy <tjm_at_runtime.dk> schreef in berichtnieuws
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
- Did you commit after submitting the job?
- Are the init.ora job parameters set? (job_queue_processes >0,
job_queue_interval)
Received on Mon Apr 14 2003 - 11:18:42 CDT
