Assuming you are making changes  to few jobs among the 100 jobs that you have , what is the difficulty in commenting the pre and post code for those few while testing?   Ideally, this type of features need to controlled via an external control tables where you have the full list of Jobs where you have set a Y/N flag to control a behavior for a particular Job. ... View more

Can you elaborate this statement ? What do you mean by executing the Job while it needs an update or enhancement ?   However I don't want this precode and postcode to execute when any of the ETL Job needs an update or enhancement     ... View more