Can an Informatica job use a template to run every x number of hours?
Could you tell which job scheduling product is related?
As you may not know, this community is used by a variety of different product groups.
We are using ESP R11.4.
Be sure to choose subcategory "CA Workload Automation ESP Edition" in the future. Otherwise other ESP users won't see it.
I think use SCHED on event level is the easiest, following will run every 2 hours:
SCHED 08.00 EVERY 2 HOURs
To use TEMPLATE, you can refer to example "Scheduling an hourly job within a time range" on "Examples Cookbook", I copied partial of the information here for you:
Scheduling an hourly job within a time range
Schedule a job to run every hour from 8 AM to 4 PM on workdays. The job belongs to an Application containing many different jobs with different frequencies.
One solution is to use a template within your Application definition.
Take the following steps:
1. Use a template in your Application to define multiple instances of the job. For example:
JCLLIB 'CYBER.JCLLIB' TEMPLATE HOURLY (1,OFFSET)
DELAYSUB 8AM PLUS %OFFSET HOURS
2. Schedule an Event prior to 8 AM that invokes this Application.
Hope this helps,
We like using the second method, with templates because the event loads all of the jobs in at once. This provides visibility to the developer as well as the operators. When an issue arises, the programmer can simply request the developers to bypass the next hour's run, hold them, etc.
You are right with the scenarios.
Originally I attempted to use the template but when I simulated, the simulate only showed the first occurrence of the job running. I didn't know if Informatica was compatible with all scheduling parms of ESP. Do you know if Informatica should work with all parms of ESP? I would prefer to use the template as other jobs will be defined for the system and I would like to only have 1 appl for the system. I will go ahead and allow the event to control the job. Thanks for your help - it is much appreciated.
Could you provide your ESP Proc here? We can check if you miss anything somehow.
I believe you should be able to use template for Informatica job.
I must have missed something when I did this originally. It worked fine just now. Many thanks for your help - it is appreciated.