|
-
Re: DBMS_JOB runtime problem
Originally posted by JMac
SQL > DECLARE
2 l_job NUMBER;
3 BEGIN
4 DBMS_JOB.SUBMIT(job=> l_job,
5 what=> 'say_hello;',
6 next_date => SYSDATE+(1/24/20) );
7* END;
SQL >/
PL/SQL procedure successfully completed.
Give commit
and check for last_date column of dba_jobs to check whether the job has run or not.
-nagarjuna
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
|