DBMS_SCHEDULER.create_job ( job_name => '<JOB Name>', program_name => '<Prgram_name>', schedule_name => '<scheuler1>', enabled => TRUE, comments => '<COMMENTS>');
920033 wrote:I already told you what job attribute to set in order to stop the job when your window closes in tyour previous topic. Since you do not seem inclined to close topics or give points as a thankyou to people who try to assist, I'm not sure I want to help again. However, to assign your job to a window, using the window and schedule you created above, all you do is this:
My requirement is , i should have to create a job of 5 minutes.if it is running more than 3 minutes it should stop automatically and run on the next day. for that i had created window for my job with window duration is of 3 minutes . my window is closed automatically after 3 minutes the job in that window will be stopped if i assign a job for it.how can i do it.
orcl> exec dbms_scheduler.create_job(- job_name=>'myjob',- schedule_name=>'window1',- job_type=>'stored_procedure',- job_action=>'p1'); PL/SQL procedure successfully completed. orcl>
orcl> exec dbms_scheduler.set_attribute(- 'myjob','stop_on_window_close',true) PL/SQL procedure successfully completed. orcl>