Re: Batch update JOB's ENVIRONMENT in specific FOLDER

[Dieter Stubler]

Hello Larry,

Here one way of doing it:

Open a terminal where you have access to the sdmsh commandline utility.
If you you have setup your $BICSUITECONFIG/sdmshrc to contain your schedulix server host and port and your $HOME/.sdmshrc contains your username and password, the following command line would do the job.
Otherwise you have to specify your credentials as parameters to you sdmsh calls. Of course you have to adapt the folder name and your new environment to your needs. 

First call:

echo "select id from sci_c_scheduling_entity where type = 'JOB' with id folder quoted;" | 

sdmsh | 

grep "^SYSTEM.'EXAMPLES'" | 

sed 's/\(.*\)/alter job definition \1 with environment = '"'"'your new environment'"'"';/'

This generates all schedulix api commands to alter your jobs. Check whether they are ok and if so, just repeat the command with and extra | sdmsh at the end to execute the commands like this:

echo "select id from sci_c_scheduling_entity where type = 'JOB' with id folder quoted;" | 

sdmsh | 

grep "^SYSTEM.'EXAMPLES'" | 

sed 's/\(.*\)/alter job definition \1 with environment = '"'"'your new environment'"'"';/' |

sdmsh

Hope that solves your request

Regards
Dieter

Larry L. schrieb am Freitag, 6. Juni 2025 um 09:37:01 UTC+2:

Hi all,

I have cloned set of schedulix job and would like to update these ENVIRONMENT value in a batch. Any ideas to do this?
Thanks.