PS Job unable to run PeopleSoft processes that contain Bind Variables.
1) Check to confirm that other PeopleSoft processes started by Automic PS Jobs are completing successfully without errors/return codes.
2) If you are able to confirm some processes complete successfully (see "1" above), but some PeopleSoft processes started by Automic PS Jobs display the symtoms described - determine if the PS job objects are using Bind variables.
The simplest way to determine this is to edit the object and confirm the "PS_SET_BINDVAR" function appears before the "PS_RUN_PROCESS" function. If so, then it is highly likely that the "optional" step, "Configuration for using bind variables", from the installation procedure for PeopleSoft Agents (Windows/UNIX) was not completed.
Some additional settings need to be specified if bind variables are used in PeopleSoft processes (ensure that the Automic interface has been installed before completing this function).
Please contact Automic Support for SQL statements.