Hello
I have a requirement to delete 25 Jobs and its corresponding Dataflow, workflows and variables. I have searched the forum and did not find much information
What should be the sequence of deleting the objects - My guess is I should first delete the parent and then do the deletion of child objects, so it will job, workflow and dataflow. how can I achieve this via a script. Our back end is oracle. What will happen to variables.
Poonam
phemrajani (BOB member since 2012-06-02)
You have the right idea. Start at the top and work your way down.
The AL_ENGINE command line utility could be use to script this. Run AL_ENGINE without any parameters and it will give you a list of all the available parameters.
An alternative would be to export the jobs you want to an ATL, recreate the repository, then import the ATL back in.
eganjp 
(BOB member since 2007-09-12)
i like the alternative… easy and ensures that novice developer makes no mistake.
Siddhant Tyagi 
(BOB member since 2013-05-09)