07-17-2013 02:21 PM - edited 03-01-2019 09:02 AM
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.
07-17-2013 02:44 PM
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
07-17-2013 03:11 PM
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.
07-17-2013 03:39 PM
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.
07-17-2013 03:27 PM
Can the file arrive multiple times per day?
07-17-2013 03:41 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide