How to update multiple jobs

yabhinav · Post by **yabhinav** » Wed Jul 29, 2009 12:37 am

Hi,
We have 50 jobs that are calling an oracle function in an oracle stage. We have recently changed the name of the function, so i need to update the all the 50 jobs!! Is there a way in this can be done in one shot?

Thanks,
Abhinav

ArndW · Post by **ArndW** » Wed Jul 29, 2009 12:55 am

I think your best bet would be to export a job with old, then make the changes and export the job again and run a "diff" on the two .dsx files. Then export all of the jobs into a .dsx file and perform a global replace on it and re-import the jobs.

yabhinav · Post by **yabhinav** » Wed Jul 29, 2009 1:28 am

Thanks for the advice , it worked!! and it was much faster than opening them manually and making the changes

ArndW · Post by **ArndW** » Wed Jul 29, 2009 1:32 am

Wow - that was fast work indeed!