System Report Queue

On this page:

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.

1. Navigate to the ReportWorks Queue page.
2. On the Refresh button, click the arrow.
3. 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.
4. 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.

1. On the start page, click the Report Queue button in the header.
2. Click the System tab. 
3. 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.

1. On the start page, click the Report Queue button in the header.
2. Click the System tab.
3. 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.

1. Navigate to the Current Reports page. 
2. 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

1. Navigate to the Completed Reports page. 
2. 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.

1. Navigate to the Completed Reports page.  
2. Click the job name of the report. 

3. 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: Completed: Job is finished. Running: Job is processing. Pending: Job has not started. Canceled: Job has been canceled.
   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: ASAP: Execute immediately. At Night: Execute during the next evening. On Weekend: Execute during the next weekend. On Specific Date/Time: Execute on the date and time specified in the following fields.
   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.

4. 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.

1. Navigate to the Report Queue Status page.

2. 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.

3. Click Refresh to update the page (optional).