Kicking off ETL from another app
Posted: Mon Dec 21, 2009 6:03 pm
I'm not sure where to go for this question or what keywords to search on.
When we kick off ETL, we've done it in one of three ways:
1. Click the run button either in Designer or Director, enter the parameters, let it run.
2. Schedule it in Director.
3. One of our jobs that needs look for a file every 5 minutes and run if it finds it. I was told not to use a loop to do this. So we setup a bat file and scheduled it to run through Windows Task Manager every 5 minutes. This required us to enter the parameter values into a txt file.
I'm trying to determine if I can have another application kick off an ETL job when the other application is done with it's processing. I'm unable to figure out how to do that with any of the above approaches.
When we kick off ETL, we've done it in one of three ways:
1. Click the run button either in Designer or Director, enter the parameters, let it run.
2. Schedule it in Director.
3. One of our jobs that needs look for a file every 5 minutes and run if it finds it. I was told not to use a loop to do this. So we setup a bat file and scheduled it to run through Windows Task Manager every 5 minutes. This required us to enter the parameter values into a txt file.
I'm trying to determine if I can have another application kick off an ETL job when the other application is done with it's processing. I'm unable to figure out how to do that with any of the above approaches.