|
-
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....
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
|