Steps to Schedule a PS Query:
-
Navigate to Reporting Tools, Query, Schedule Query or Query Viewer
-
Select query name or portion of query name.
-
Select a run control id and description (preferably) use the same name as query name
-
Input parameter values if any exists
-
Select Server name from dropdown
-
Navigate to process monitor to see the query running
Step# 1
Step#2 : Click on "Schedule",
Step#3: Copy query name to Run Control id and Description & click OK.
Step#4 : Enter prompt values if a pop-ip occurs & click OK.
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.
Step#6
Navigate to process monitor to see the query running.