In my previous article you have seen how to schedule a concurrent program from back end, now let us see how to schedule a concurrent program through oracle application.
You might be having couple of requirement where you want to run the report daily, weekly, monthly or on specific day at specific time.
For example: In finance company they want to run GL daily rate report every day midnight at 01:00 AM or other reports like 'Invoice hold report' run on specific days at specific time so every time submitting concurrent program is not possible manually. So Oracle introduced scheduling feature where users can schedule concurrent program as per their need.
Before we step in how to schedule a concurrent program, let us see what are the different scheduling features we have,
- Once
- Periodical
- On specific day
- Advanced (majorly not used)
Nav: Go to desired responsibility --> View --> request click on submit request and click on single request
Now enter the concurrent program name, parameters and click on schedule button
under run the job.. click on Once and enter the run time as per your requirement
Now click on submit button
In the below screen shot you can see the program status has scheduled and phase as pending. on specific time it will change the status to running.
Now on time the program has scheduled
Now the program completed sucessfully
- Periodical Schedule:
Now under run the job.. click on 'Periodically' and enter the run time as per your requirement
Now click on ok and submit the request
Now on time the program has scheduled
As soon as it completes the program a new program has schedule after a minute
Now on time the program has scheduled
you can see both the programs had completed successfully
- On Specific Days Schedule:
But for the below request it run on 3rd, 5th and last day of the month.
click on Ok and submit the request.
Program has submitted as per the scheduled time.
Now the next program has scheduled with status as scheduled to check the schedule time click on 'schedule'
if you see the requested start date next schedule is on 5th.
In these way we can schedule the concurrent programs according to your requirements.
We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Technical Action Group IT Solutions
ReplyDeleteWe need to Schedule a Program for Every 4 hours in every 5 days (Not on Friday & Saturday) of the week. how can i do it?
ReplyDeleteWe are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.
ReplyDeletehttps://www.technicalactiongroup.ca/
I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion Financials.Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDelete