dbms_job.submit

[kodaksmile]

I submitted a job through dbms_job.submit as follows:

DECLARE
job_num PLS_INTEGER;
BEGIN
DBMS_JOB.SUBMIT(job_num, 'CCR_WORKFLOW_TITLE_UPDATE;',SYSDATE,'trunc((sysdate)+1)+120/1440');
DBMS_OUTPUT.PUT_LINE ('Assigned Job #:' || job_num);
End;

It said the pl/sql package completed but, did not return a job number. When I look in dba_jobs and do a select * no rows are returned. Did this really take???? Thanks

 

[karluk]

The usual reason for not seeing output from dbms_output.put_line is forgetting to set serveroutput on. However I don't know why you don't see anything in dba_jobs. It's very odd that you don't see the job but didn't get an error message from dbms_job.submit.

 

[sem]

Did you issue commit? As for not printing job_num, I'm agree with Karluk.

 

[kodaksmile]

I did issue a commit - so I ran the same statement again in sql plus (had run it in sql worksheet the first time) waited 15 minutes and queried dba_jobs and found 2 jobs now present (maybe I just didn't wait long enough) and in sql plus it did send back a job number of 3 - so I deleted job 2 and all looks good - Thanks for your help.