I'm using the Oracle scheduler jobs to schedule my application Backup and its perfectly working. And for manual Backup I run the same job by PLSQL code like
DBMS_SCHEDULER.RUN_JOB(JOB_NAME => 'CREATE_BACKUP', USE_CURRENT_SESSION => FALSE);
So user can schedule backup from 1 Dec 2020 to 7 Dec 2020 then the END_DATE of the job is set as
07-DEC-20 04.35.00.000000000 PM ASIA/CALCUTTA
Consider this END_DATE is passed(Consider current date is 08-Dec-2020) so the job won't be running from now. But If I try Manual backup(run job through code with above mentioned code) the job is not running anymore since it has passed the END_DATE . Can anyone help me to run the job or am I missing anything to run the job from code.
I can't directly run the procedure in the job for manual backup because whether the job is manual or scheduled many part of the application is checking whether the backup is running or not by checking the job status.
It would be so helpful if someone can help me around this. Thanks in advance.