Q
Problem solve Get help with specific problems with your technologies, process and projects.

Running a recurring job at another specific time

I have writtem this job to run on every Friday at 7:00 p.m., and it is working fine:

DECLARE

/*
** Procedure to schedule the BOM extract Procedure
** every Friday at 7.00 PM
*/

   job_no BINARY_INTEGER;

BEGIN

   dbms_job.submit( job_no
                  , 'BEGIN; kesh_bom(5); END;'
                  , (NEXT_DAY(TRUNC(SYSDATE), 'FRIDAY') + 19/24)
                  , 'NEXT_DAY(TRUNC(SYSDATE), ''FRIDAY'') + 19/24' 
                  , FALSE
                  );
END;
Now I want to run this job on 02-Mar-03 at 10:00 a.m. How can I go about it?

Since it appears that you only want to run the job once in addition to your regular routine, then the easiest way is to simply submit another job to run at the given time you desire. Don't set an interval for repeating it and it will only run the one time. You can remove the job after it runs.

For More Information


This was last published in March 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close