System Report Queue
Use the System Report Queue to view, delete, cancel, and re-execute preconfigured reports that you submit to the queue. When you submit a report request to the system, the system captures the report request and transmits the job to the Report Queue. The Report Queue page displays the status of the report as it is processed by the system. The Report Queue also includes debugging tools and logs to troubleshoot problems with reports.
Reports are organized by tabs. The System tab displays all preconfigured reports, while the ReportWorks tab displays all submitted reports that were created in ReportWorks. For more information about viewing ReportWorks, refer to ReportWorks Report Queue.
To view all jobs in the report queue regardless of the user, view the report queue from the System Administrator menu. Administrators can also set preferences for the Report Queue. For more information, refer to Report Queue Preferences.
Set Automatic Page Refresh on the Report Queue
You can choose how often the ReportWorks report queue automatically refreshes. This feature is available on the System Reports Report Queue and the ReportWorks Report Queue.
Navigate to the ReportWorks Queue page.
On the Refresh button, click the arrow.
Select the unit of time for the automatic page updates; 30 seconds, one minute, five minutes, or 10 minutes.
A countdown clock appears on the Refresh button and displays the time until the page updates, based on your selection.To cancel the automatic page refresh, click the arrow and select the Cancel button.
View System Reports in the Report Queue
You must run a report before performing this procedure, otherwise the Report Queue will not be available from the header. For more information, refer to Custom Reports or Preconfigured Reports.
On the start page, click the Report Queue button in the header.
Click the System tab.
Do one of the following:
Click Refresh to update the page.
Click the cancel icon to stop running the report.
Click View to view the report once the Status column displays the status Completed.
Click the Job Name of the report. Select either Cancel Job or Run job again, depending on whether the job has been completed or not.
Click the trash icon to delete the completed report.
View Completed System Report Details
When a report runs completely, view the job details. You must run a report before performing this procedure, otherwise the Report Queue will not be available from the header.
On the start page, click the Report Queue button in the header.
Click the System tab.
Click the job name of the report.
If the report is a merger of multiple report definition (RPT) files, this field displays the text MERGE. If the report was not a merger report, nothing appears in this field.
If the job has not been completed, you can select Cancel Job? to cancel the execution of the report.
If the job has been completed, you can select an option for When to Execute and select Run job again? Click the file name to access the report file.
View Report Queue Jobs
You must run a report before performing this procedure. For more information, refer to Custom Reports or Preconfigured Reports.
Navigate to the Current Reports page.
Do one of the following:
Click Refresh to update the page.
Click the job name of the report.
Select the Cancel checkboxes for the reports you want to cancel. Click Cancel Selected Jobs.
View Completed Report Queue Jobs
Navigate to the Completed Reports page.
Do one of the following:
Click Refresh to update the page.
Click the job name of the report.
Select the name of the result file to display the report.
Report Queue Job Details
View report job details.
Navigate to the Completed Reports page.
Click the job name of the report.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
User | The username of the person who ran the report appears. |
School | The school name and number for the report appear. |
Created | The date and time the report job started appear. |
Job Name | The name of the report appears. |
Type | The way in which the report is generated appears. |
Reports | The name of the table that includes the data used for the report appears. |
Status | The status of the report job appears:
|
Started | The date and time the report started running appears. |
Ended | The date and time the report finished running appears. |
When to Execute | Select a time to run this report:
|
Run Job Again? | Select the checkbox to run the report again. |
Result File | Select the result file to display the report. |
File Size | The size of the file appears. |
Location on Server | The file location on the PowerSchool server appears. This information is available for completed jobs only. |
Priority | Enter a priority for the report. Lower numbers give the report higher priority. This information is available for pending jobs only. You can further modify priorities on the user group security pages. For more information, refer to Group Security Permissions Setup. |
Click Submit to save your changes.
View the Report Queue Status
The Report Queue Status page displays information about past and current jobs in the report queue. The content of this page varies depending on the status of the report jobs. For example, you can cancel any jobs with the status Pending or Running, whereas you cannot modify Canceled or Completed jobs.
Navigate to the Report Queue Status page.
Use the following table to understand the fields in the Report Queue section:
Field | Description |
|---|---|
Current status | Status of the entire report queue. The report queue can be running or not running. Other error or status messages pertaining to the entire report queue may appear. |
Last restarted | Date and time of the last time the job was restarted. |
Number of report processes | Number of report processes currently running in PowerSchool. |
Automatically delete completed jobs after | Number of days that a job remains in the report queue. To modify this number, refer to Report Queue Preferences. |
Maximum pending jobs per user | Maximum number of jobs any one user can have pending in the report queue. To modify this number, refer to Report Queue Preferences. |
Result file location | Location of the report results on the PowerSchool server. |
Use the following table to understand the fields in the Job Statistics section:
Field | Description |
|---|---|
Currently running jobs | Number of jobs currently running. |
Last job run | Date and time of the last job to run. |
Jobs run today | Number of jobs run so far today. |
Total jobs ever run | Number of jobs ever run in PowerSchool on this server. |
Pending jobs on server | Number of jobs currently with the Pending status. Click the number to display the jobs. |
Completed jobs on server | Number of jobs currently with the Completed status. Click the number to display the jobs. |
Canceled jobs on server | Number of jobs currently with the Canceled status. |
Total jobs on server | Number of jobs currently on the server with any status. |
Use the following table to enter information in the Report Processes section:
Field | Description |
|---|---|
Process Name | Names of the currently running report processes. |
Jobs Run | Number of jobs run for each process. |
Total Time | Total time each process took. |
Status | The status of each process appears. If the job is running, the name of the report appears. Click the report name to display the job details. To cancel the report, select the checkbox and click Cancel Selected Jobs. When a job completes, the report name no longer appears in the Status column. |
Click Refresh to update the page (optional).