How to Run SQR Runner Job

This article provides information on how to run a SQR runner job.

Detailed Information

Table of Contents

• Access SQR Runner
• Upload Input Data
• Run SQR
• Access Result

SQR Runner allows users to run custom SQR scripts for which they have been granted run access.

Access SQR Runner

To get to SQR runner, follow these steps to CSRPT, the reporting database for student information.

1. Log in to your MyCampus portal. Expand the MaineStreet menu to find "Reporting (CSRPT)".
   
2. Your Reporting Homepage tiles appear.  Select SQR Runner.
   
   

Back to Top

Upload Input Data

1. A menu will appear on the left side of the screen. Expand Run SQR. Select Input File Upload.
   
   
    
2. If the ID of the SQR is known, it can be entered in the SQR ID field. If unsure, just click the Search button.
   
   
   
   If there is only a single SQR available, the system will redirect to that SQR. Otherwise, the user will be asked to choose the SQR file they wish to alter.
   This will allow for the data upon which the SQR will act to be loaded into the system. This process expects a file of a certain name, which should be specified when SQR run access is granted for the specific script.
   The display for uploading input files allows users to either upload new files, delete old files, or replace existing files. This is the choice of the user as to whether they wish to maintain a history of past run data in this form.
    
3. To upload a new file, click the PLUS icon in the latest row.
   
   
    
4. Follow the instructions to upload the file and enter a description, if desired (this is not necessary as the system will use the filename by default).
   
   
    
5. Uploaded file can now be seen at the bottom of the list. Before moving on, click the Upload button.
   
   
    
6. A message will appear, and the result of the upload will be available in the Results text box. Select OK.
   
   
    

The attached file is now available in the "SQR Input File Attachments" box.

Back to Top

Run SQR

1. Click the Run SQR link in the left column to run the SQR with the newly uploaded data.
   
   
    
2. Either select an existing Run Control ID, or create a new value.
   
   
    
3. The SQR ID must be entered again. Click the Search Icon next to the text box for Select SQR Id to see the list of SQR scripts that are accessible.
   
   
    
4. Click the SQR ID to run.
   This will populate the list of parameters that must be filled for the selected SQR script. The parameters are specific to each SQR, and are navigable via the Enter Process Parameters controls. The example below has 5 distinct parameters that must be entered. Ensure that all values are entered prior to running the script.
   
   
5. Continue until all parameters for your specific SQR are entered. The image below is parameter 2 of 5.
   
   
    

Once this is complete, click the Run button. A pop-up notification will appear showing the status. Click OK.

.

Back to Top

Access Results

1. To monitor the process, click on the Process Monitor link. This will bring up the Process Monitor with the current running processes and any processes that have been run within the date range specified.
   
   
    
2. The output of the run will be available once the Run Status is changed to Success.
   
   
    
3. Once the process is complete, click on the Details link.
   
   
    
4. Output from the process is available via the View Log/Trace link under Actions. Output files will be available for download here, as well as any log files produced by the process.