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.
mass update of condition in the steps tab
- be_incontrol
- Nouveau
- Posts: 13
- Joined: 26 Sep 2008 12:00
- nicolas_mulot
- Nouveau
- Posts: 149
- Joined: 07 Jan 2010 12:00
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
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
- be_incontrol
- Nouveau
- Posts: 13
- Joined: 26 Sep 2008 12:00