mass update of condition in the steps tab

All questions about Control-M jobs definitions
Post Reply
User avatar
be_incontrol
Nouveau
Nouveau
Posts: 13
Joined: 26 Sep 2008 12:00

mass update of condition in the steps tab

Post by be_incontrol » 25 May 2011 1:41

Hello Control-M experts,

Is there a way to mass update the do condition in the steps tab? We are running 6.3.01 ver. We have around 300 jobs that needs to be updated, i.e for the do condition from <condition>_Dv to <condition>_Ut.

Thanks in advance.

User avatar
Eight
Nouveau
Nouveau
Posts: 41
Joined: 03 May 2010 12:00

Post by Eight » 25 May 2011 8:02

In 6.4 you can do the following (give it a try)...

* Select "+" --> Update/ Steps / Step Code / name
* Change: assign to replace substring
* Enter 2 values --> _Dv _Ut

User avatar
nicolas_mulot
Nouveau
Nouveau
Posts: 149
Joined: 07 Jan 2010 12:00

Post by nicolas_mulot » 26 May 2011 8:06

be_incontrol,

I noticed you run 630. In 640 the structure of the EM tables has changed.

The following sql request should do the job (supplied in MS/SQL format, against the EM database)

update DEF_DO_COND set CONDITION = replace(CONDITION,'_Dv','_Ut') where CONDITION like '%/_Dv' escape '/'

Additional filtering should be required to target a specific data center, such as:

and TABLE_ID in (select TABLE_ID from DEF_TABLES where DATA_CENTER ='YOUR_DC_NAME')

Pls make a global save, for example by exportdeftable, before running this. Even if the result is not OK, you may always use the server database as a backup and perform a mass table_download later on.

Cheers
Nicolas Mulot

User avatar
be_incontrol
Nouveau
Nouveau
Posts: 13
Joined: 26 Sep 2008 12:00

Post by be_incontrol » 31 May 2011 11:58

Hi Eight and nicolas_mulot,

Thanks a lot for all your answer and suggestions. Since our Administration team is outsourced to a different company of which they have access to the database, I will meet with them and supply to them the details you both have given.

regards,
be_incontrol

Post Reply