![]() ![]() The Parameter List is where we pass all of the arguments to our wrapper script. For the Command Line, set it to powershell.exe.Select Other as the Generic Process Type.Select ORACLE as the Database Type and the Platform as Windows.Navigate to PeopleTools > Process Scheduler > Process Type.To configure your process scheduler to run Powershell scripts, we need to configure a new Process Type and enable the server to run the new type. Scheduling and executing those interfaces from the Process Monitor brings the visibility of the scripts into PeopleSoft where all your batch jobs are logged. It’s common to use the Windows Task Scheduler to run Powershell scripts, but users have no visibility as to when the scripts run or if they completed successfully. The main use case I see is interfaces that are run from the OS you can now schedule and execute from within PeopleSoft. ![]() There are a number uses for bringing Powershell scripts into the Process Monitor. To get started, download the scripts in the repository to c:\psft\tools. This is an Oracle-specific script, but it could easily be updated to work with SQL Server or DB2. The instructions below are an abbreviated version with small changes specific to Powershell.Īll of the code is posted on GitHub in the ps-powershell repository. For a detailed description of how to configure shell scripts to run, visit here. In my case, I have a number of Powershell scripts to run so I re-implemented David’s solution in Powershell. While making the process scheduler run shell scripts or Powershell scripts isn’t hard, the best part of David’s wrapper script is that it adds a layer to make your scripts API aware with the Process Monitor. Thankfully, David Kurtz offered a solution for that a while back, and revisted the solution recently. The PeopleSoft Process Scheduler supports many different types of tools to run, but one thing it lacks is support to run shell scripts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |