-
Dbms_job
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....
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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!
-
Re: Dbms_job
This should work ...
Code:
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;
-
Thank you very much for the information!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|