Conditional dependency?

seancasey4 · ‎07-17-2013

We're new to Tidal. Running v. 6.1.0.279 on Solaris.

We have the following requirement:

If a file exists, run Job A, then run Job B

Else run Job B.

We know how to use a File Event to Launch Job A when the file exists, and have Job A launch Job B. (The IF)

Is there any to accomplish the else?

Thanks for any help.

seancasey4 · ‎07-17-2013

A follow-up: Job A takes about 1 minute to process.

One idea is to just schedule Job B to run 30 minutes after Job A and run it unconditionally, but that "wastes" 30 minutes in an already overfull load window if the file is present and Job A has run.

Is there any way to have Job A do an Override of the schedule of Job B? That would allow Job B to run earlier when Job A had run.

Thoughts?

Sean

Prakash Hemchand · ‎07-17-2013

You could just schedule job B to run directly after job A.

Setup Job A to process the file when it's present or simply 'exit 0' if the file is missing.

seancasey4 · ‎07-17-2013

Yes, that is the "workaround," to just run Job B unconditionally at a time that insures that Job A has completed, if it ran.

These are Informatica Jobs. Don't really have a easy way to test for the file and then exit if not present. Setting up a File Event and Job Action to run Job A when the file IS present works, tho.

Prakash Hemchand · ‎07-17-2013

Can the file arrive multiple times per day?

seancasey4 · ‎07-17-2013

Not sure, but the requirement is to process it only once per day, first thing in the morning. It contains data used for BI, and those reports and dashboards are only published once per day.