Informatica & Templates

[BARB RUPP]

Can an Informatica job use a template to run every x number of hours?

[Lucy Zhang]

Hello,

 

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.

 

Thank you,

 

Lucy

[BARB RUPP]

We are using ESP R11.4.

[Lucy Zhang]

Hello,

 

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:

EVENT ID(TEST.INFORMATICA_JOB)

SCHED 08.00 EVERY 2 HOURs

....

ENDDEF

 

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

 

Objective

 

 

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.

 

Solution

 

 

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:

 

APPL CYBER

 

JCLLIB 'CYBER.JCLLIB' TEMPLATE HOURLY (1,OFFSET)

 

JOB A.%OFFSET

 

RUN WORKDAYS

 

DELAYSUB 8AM PLUS %OFFSET HOURS

 

ENDJOB

 

ENDTEMPL

 

HOURLY 0

 

HOURLY 1

 

HOURLY 2

 

HOURLY 3

 

HOURLY 4

 

HOURLY 5

 

HOURLY 6

 

HOURLY 7

 

HOURLY 8

 

2. Schedule an Event prior to 8 AM that invokes this Application.

 

 

 

Hope this helps,

 

Lucy

[Jonathan Calloway]

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.

 

 

[Lucy Zhang]

Hi Jonathan,

 

You are right with the scenarios.

 

Thank you!

 

Lucy

[BARB RUPP]

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.

[Lucy Zhang]

Hello Barb,

 

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.

 

Lucy

[BARB RUPP]

I must have missed something when I did this originally.  It worked fine just now.  Many thanks for your help - it is appreciated.