You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to pass a stored password to a job step

Received Response
edited May 19, 2023 12:46PM in Visual Builder Studio 2 comments


Trying to pass a #{variable} password stored in the project to a sqlcl step or a shell script type step in a job.

Content (required):

We have been passing password variables by using a parameter in the job. That works well for a single password.

However, we frequently have the need to select from a list of passwords and pass that variable to a sqlcl or shell script step in the job, if I use the #{var} format it won't be replaced within the step.

We've also tried a dropdown list $passwd_selection like this:




but the $passwd_selection will not replace to the actual stored password.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!