ESP Workload Automation

Expand all | Collapse all

Informatica & Templates

Jump to Best Answer
  • 1.  Informatica & Templates

    Posted 04-29-2016 02:51 PM

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



  • 2.  Re: Informatica & Templates

    Broadcom Employee
    Posted 05-10-2016 07:31 AM

    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



  • 3.  Re: Informatica & Templates

    Posted 05-10-2016 07:48 AM

    We are using ESP R11.4.



  • 4.  Re: Informatica & Templates
    Best Answer

    Broadcom Employee
    Posted 05-10-2016 08:11 AM

    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



  • 5.  Re: Informatica & Templates

    Posted 05-10-2016 08:27 AM

    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.

     

     



  • 6.  Re: Informatica & Templates

    Posted 05-10-2016 08:49 AM

    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.



  • 7.  Re: Informatica & Templates

    Broadcom Employee
    Posted 05-10-2016 08:43 AM

    Hi Jonathan,

     

    You are right with the scenarios.

     

    Thank you!

     

    Lucy



  • 8.  Re: Informatica & Templates

    Broadcom Employee
    Posted 05-10-2016 08:58 AM

    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



  • 9.  Re: Informatica & Templates

    Posted 05-10-2016 09:17 AM

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