02-18-2012
41,
1
Join Date: Aug 2005
Last Activity: 8 November 2016, 2:36 PM EST
Posts: 41
Thanks Given: 0
Thanked 1 Time in 1 Post
Help in script
I have a script that calls an ETL job and passes paramaters like job name. The jobnames is built dynamically each time the script is triggeerd. Once the Jobnames param file is built, the process loops (based on the line count of jobnames param) to all the ETL job. All this is workign good. I need to add somme more functionality into the script. Here si the requirement:
1. Assuming the param file has 10 lines (meanening it has to call the ETL script 10 times in a loop)
2. When I start the script, after looping 4 times, lets say the process fails.
3. When I restart the script again , I need to make it only start from where it left. So, it should only start from 5th job (assuming the 4 runs were successful)
4. I should be able to pass a switch which tells that its not like afull load and its more like incremental.
Can anyone throw some pointers for this? Thank you.