This content has been marked as final. Show 12 replies
One follow up question: I have to run another program from Monday to Friday at 6am...which is fine since I can use the "On Specific Days" schedule.
Now, on certain Mondays (twice a month), I need to run that program at 11am instead of 6am....this seems to cauase a conflict with the schedule above. How can this be achieved?
The setting up first part from Mon-Fri at 6am is simple _(Requirement 1) ._
How do I create a separate run of the same program to run at different times on 2 Mondays? _(Requirement 2)_
Do I have to create a new concurrent manager, assign work shifts for requirement 2. I'm not sure how to proceed on requirement 2.
AFAIK, this cannot be achieved from the application (schedule the concurrent program on certain days and exclude two days (for example, two Mondays in a month) -- Please log a SR to confirm this with Oracle support.
As mentioned in the document, you could write a cron job and specify the date/times you want to schedule this concurrent program using CONCSUB.
Hi Autoconfig - Any updates?
Also, I have one more issue. We're scheduling our program from Mon-Fri and it has 2 parameters - Start Date and End Date.
The start date has to be specific date i.e 01-FEB-2011 for the next 15 days and then 16-FEB for the next 15 days.
The end date = sysdate -1.
When I run the program individually every day, it works fine. But we can't run manually everyday so we're scheduling it and this is where I'm stuck.
When I schedule the program using "On Specific Days" options and choose Mon-Friday, the first time the program runs fine from 01-Feb to 06-FEB (assuming today in 7th Feb). When it's automatically scheduled for the next day....it keeps the same parameters....even though I want _01-FEB to 07-FEB on 8th Feb_ and _01-FEB to 08-FEB on 9th Feb_. However, it just keeps 01-FEB to 06-FEB - the first time parameters that were used.
If I use the "Increment Dates with each run" option, it increases the start date which is what I don't want. How can I keep a start date fixed for certain amount of time and keep end date = sysdate -1 while scheduling a program.
Any help is greatly appreciated.
Edited by: user10541583 on Feb 7, 2011 7:33 AM
My program has 2 parameters - Start and End Date...both are SQL parameters.
The "End Date" = SELECT SYSDATE-1 FROM DUAL
The "increment date on each run" is NOT checked.
When I schedule the program, the "End Date" still shows dates 2 days old (when the program was originally submitted), where as it should be showing "sysdate-1"
How can I make my "End Date" = Sysdate-1 while scheduling the program? My start date has to remain the same as per a lookup.