CODEWITHSUNDEEP
admininformatica-powercenter
Raghav Rao
Raghav Rao

Reputation: 43

scheduling an informatica workflow with a customized frequency

Hello Dear Informatica admin/platform experts,

I have a workflow that i need to scheduled say Monday-Friday and Sunday. All the 6 days the job should at a specific time say 10 times in a day, but the timing is not uniform but at a predefined time say(9 AM, 11 AM, 1:30 PM etc), so the difference in the timing is not uniform. so we had 10 different scheduling workflows for each schedule/run that triggers a shell script that uses pmcmd command.

It looked a bit weird for me, so what i did was, have a single workflow that triggers the pmcmd shell script, and have a link between the start and the shell script where i specified a condition of the time and scheduled it to run monday-friday and sunday every 30 minutes.

So what happens is, it runs 48 times in a day but actually triggers the "actual" workflow only 10 times. and the remaining 38 times it just runs but does nothing.

one of my informatica admin colleague says that running this 38 times(which does actually nothing) consumes informatica resources. Though i was quite sure it does not, but as i am just an informatica developer and not an expert, thought of posting it here, to check whether it is really true?

Thanks.

Regards Raghav

Upvotes: 0

Views: 1090

Answers (1)

Maciejg
Maciejg

Reputation: 3353

Well... it does consume some resources. Each time workflow starts, it does quite a few operations on the Repository. It also allocates some memory on Integration Service as well as creates log file for the Workflow. Even if there are no sessions executed at all.

So, there is an impact. Multiply that by the number of workflows, times the number of executions - and there might be a problem.

Not to mention there are some limitations regarding the number of Workflow being executed at the same time.

I don't know your platform and setup. But this look like a field for improvement indeed. A cron scheduler should help you a lot.

Upvotes: 1

Related Questions