HCM: Setup Queries For Batch Processing

Tags Query Batch

Steps to Schedule a PS Query: 

  1. Navigate to Reporting Tools, Query, Schedule Query or Query Viewer 

  1. Select query name or portion of query name.  

  1. Select a run control id and description (preferably) use the same name as query name 

  1. Input parameter values if any exists 

  1. Select Server name from dropdown  

  1. Navigate to process monitor to see the query running 

Step# 1 

Uploaded Image (Thumbnail)

Step#2 : Click on "Schedule",

Uploaded Image (Thumbnail)

Step#3: Copy query name to Run Control id and Description & click OK.
 

Uploaded Image (Thumbnail)

Step#4 : Enter prompt values if a pop-ip occurs & click OK.
 

Uploaded Image (Thumbnail)

The query will be running in process monitor where you will be able to retrieve the spreadsheet results. 

Step#5: Select Server name from dropdown & click OK.
 

Uploaded Image (Thumbnail)

Step#6 

Uploaded Image (Thumbnail)

Navigate to process monitor to see the query running.

Was this helpful?
100% helpful - 1 review
Print Article

Details

Article ID: 148431
Created
Mon 12/11/23 12:56 PM
Modified
Mon 9/16/24 10:59 AM