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
42
Views
2
Comments
edited May 19, 2023 12:46PM in Visual Builder Studio 2 comments

Summary:

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:

#{var1}

#{var2}

#{var3}

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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