Hide parameters in Execute Commnad Stage

[jflandez]

I'm executing an osql command using the Execute Command Stage and i need to hide the -P (Password) parameter. I'm using an Environment Variable but the password shows up in the logs. How can I hide the parameters in the Event Detail Logs?

Thanks,

Jose

[chulett]

Welcome. :D

You'll probably need to write your own version of the Execute Command as a custom routine to leverage the 'Silent' version of the appropriate Exec function. For example, on UNIX servers there is:

ExecSH
ExecSHSilent

I'm assuming the same is true for a Windows server. If not, you could easily code one, I would wager. Then run it using the Routine Activity stage rather than the Execute Command stage in your Sequence job.

[jflandez]

Thanks! I'll give it a try.

[chulett]

Clarification, in case I wasn't clear. For Windows you should have these as equivalents to the UNIX SH(ell) functions:

ExecDOS
ExecDOSSilent

From what I recall... no Windows servers here.