Not within the built in scheduler. You would have to use an external tool for that type of scheduling requirement or a script to call the task.
Thanks for your reply, How and where do we write a script and what type of script would be required for this task?
it could be a shell/bash script depending on your Secure agent server os. That script can check the sysdate for what day of the month it is and from there kick off said mapping task. You can kick it off via the runAJob CLI or an API call.
You could also create a java or python script...it really is up to you on that front.
Then you can schedule a taskflow to call said script that runs everyday and the script takes care of checking if the date is right and kicks off the mapping task to load data.
dumb question from an IICS-agnostic (myself): do task flows provide link conditions like in PowerCenter?
In this case the solution depicted in some similar PowerCenter-related questions may come in handy here.
This solution basically works as follows:
A first mapping checks whether "today" is one of those days when the whole task flow is supposed to run.
If so, the mapping produces one dummy output record.
If not, the mapping does not produce any output.
Now the link condition would pass control to the next mapping (the first "real" mapping) only if the first mapping succeeded and did produce some output (i.e. number of success target records > 0).
Does this work in IICS as well? This would enable the original poster to implement a solution without the need for any "external" scheduling mechanism.
good idea. Yes this would work in IICS taskflows as well.
Based on what Nico mentioned here is what you could do with mappings and a taskflow.
inside a taskflow
mapping 1 check if the date is day 1-7. If so output a dummy file, if not those dates end.
decision task (simulates link conditions from PC). If data task 1 outputted a success row it is day 1-7 proceed to mapping 2. If success rows 0 then end workflow.
mapping 2: data load.
first thanks a ton for the info.
Second one follow-up: if I understand correctly, everything that can be done via workflow link conditions in PowerCenter can be done in IICS using Decision tasks?
Thanks and regards,
1 of 1 people found this helpful
That's correct Nico