Dbms_job

[cchiara]

I have set up a DMBS_JOB with the syntax below:

VARIABLE jobno number;
BEGIN
dbms_job.submit(:jobno,
'reset_nbr;',
SYSDATE, 'null');
END;
/

When I check data dictionary on DBA_JOBS, the job is on the queue. But somehow it is not executing. Am I doing anything wrong?
Also, is it possible to set the job to run at the specific time of the day?

Thank you in advance....

[jmodic]

COMMIT;

[cchiara]

When I did DBMS_JOB.RUN, it was executed immediately and was able to test it.

Could you please tell me how I could set the job to run on the 1st of each month at 2am?

Thanks!

[slimdave]

This should work ...

VARIABLE jobno number;

Begin
  DBMS_Job.Submit
     (
     job => :jobno,
     what => 'reset_nbr;',
     next => Trunc(SysDate,'MM')+(2/24),
     interval => 'Trunc(SysDate,'MM')+(2/24)'
     );
End;
/
Commit;

[cchiara]

Thank you very much for the information!