Thursday, July 28, 2011

Increment date parameters each run


Navigation : Concurrent -> Request -> Run --- Click on "Schedule" Tab

Option : "Increment date parameters each run" while scheduling a Conc Request.

Some time we will get a requirement to schedule Conc Requests that take "Date" as one of the parameters.
By default when we schedule such requests Data filed defaults to SYSDATE. But we need the date to be always the system date at that point of time when ever the scheduled prog  runs. Then we need to check this option. Otherwise, its an optional option.

For eg : Today I am scheduling a Conc Request "Close WIP Jobs" to run every Sunday Mid Night 01:00 am and the Conc Request takes "Date" as one of the arguments as this prog is to close all open WIP jobs till that time since last run. ie. For eg  if this needs runs on 2nd July, 9th Jul, 16th Jul weekly and when even it runs it has to take the current date ie when it run on 2nd then it has to automatically increment date parameter to 2nd so that it can close the WIP jobs till that day and when its runs on 9th..it has to again automatically increment date as 9th Jul instead of 2nd July so that it call close all that WIP jobs till that date and time.

In such cases this option helps you.

Ref Note : 1245684.1


UR's Key Run ;-) 

No comments:

Post a Comment