Hi
We have a need to replicate data on an data in an upstream system (which is a vendor product platform with a propritary database) into a data warehouse every hour. In order for this, we need to run close to 300 jobs every hour. all these jobs bring in various kind of data and populate a normalized data warehouse model.
until recently these jobs are running fine, but recently we have seen an increase in CHASE ALERTS ( essentially the autosys job takes more than 120 secs to start a workflow).
I have 2 questions:
1. Is this a bad design? we have been using this model for the last 4 years or so, running fine.
2. What could be the reason for the chase alerts?
3. What could be a better/alternate ways to resolve the problem.
Thanks