Job Scheduler

Listing of jobs (i.e. reports or report bundles) scheduled to be generated at a specified date and time.  Scheduled jobs can be viewed, edited or deleted. 
Users will see all jobs they have scheduled. Administrative users can view Jobs scheduled by all users.

To update the Status of the Job, click on :

View Scheduled Job

Click the View  icon to view Job Identity details. These details include the Job Type, Name, and Description. 

To view additional details, click on the row of the job in the grid to open the highlight view. 

• Type: Indicates whether the Job was scheduled by System or a User account.
• Name: Name assigned at the time the job is scheduled. This should be unique for each Job.
• Username: Indicates the user account that scheduled the Job.
• Status: Indicates whether the Job is Completed, Failed, or pending. This status can be refreshed by clicking the  icon.
• Job Result: Contains additional details for Jobs with a Failed status.
• Last Run: Shows the date the Job was last completed.
• Next Run: Shows the date the Job is scheduled to run next.

Edit Scheduled Job

Click the Edit  icon to edit the Job Name or Job Identity details. 

Create Audit Jobs

The Create option is used to schedule District Audit Job and SOC1 Audit Job. Audit Jobs are available to assist ITCs and districts with generating and submitting the necessary reports to AOS for both site and SOC1 audits. These jobs can be scheduled directly through the Job Scheduler on the Utilities menu. When the Audit Job runs, it will send a list of preconfigured reports to the File Archive under the Audit Files tab. The reports are also zipped and securely sent to the Auditor of State via SFTP.

Each Audit Job is preconfigured to include certain reports required by the Auditor of State. These include the SOC1 Audit Job, used by ITCs, and the District Audit Job. The jobs store all necessary parameters for all reports. When they run, the jobs will generate new reports for the prior fiscal year, which is determined by the current period.

District Audit Job

The District Audit Job runs the following reports:

• SSDT USAS Auditor Extract
• SSDT USAS Auditor Extract - Transaction
• SSDT USAS Auditor Extract - Vendor
• SSDT Cash Summary
• GAAP Extract

Job Type: class org.ssdt_ohio.usas.reporting.audit.DistrictAuditJob

SOC1 Audit Job

The SOC1 Audit Job runs the following reports:

• SSDT User Listing AOS Extract
• SSDT Authentication and Password Requirement Configuration Report
• SSDT Default Breakin Detection and Evasion Rule Report

Job Type: class org.ssdt_ohio.usas.reporting.audit.SOC1AuditJob

Schedule to Run

The Audit Jobs can be scheduled to run on custom intervals. This will depend on the Cron Expression entered when scheduling. Once the Audit Job is set up, it will appear in the Job Scheduler with a Next Run date and time.

1. Navigate to the Utilities menu > Job Scheduler
2. Click  at the top of the grid. This will open a pop up window with the options to schedule the Job.
   
3. Select the Job Type from the drop down
   1. District Audit Job: class class org.ssdt_ohio.usas.reporting.audit.DistrictAuditJob
   2. SOC1 Audit Job: class org.ssdt_ohio.usas.reporting.audit.SOC1AuditJob
4. Enter an Event Trigger

   1. The Event Trigger is where the Cron Expression will be entered to schedule the job. The Cron Expression represents the frequency at which the job should run. 

      Cron Expression

      1. A Cron Expression is a command set up to run periodically at fixed times, dates, or intervals. Cron Expressions can be generated using an online source for the desired time period and then copied and pasted into the Event Trigger field.
         
         

         Free online cron expression generators:

         • https://www.freeformatter.com/cron-expression-generator-quartz.html 
         • http://www.cronmaker.com
5. Click  to schedule the Job

Audit Job Output

Reports from the Audit jobs will be zipped and sent to the Auditors of State via SFTP. The zipped file names include the district IRN, fiscal year, description and the date and time the file was generated.  

The files will also be stored under the Utilities/File Archive - Audit Reports tab:

The Audit Files grid will contain 2 entries per fiscal year, one for each of the new audit jobs once they have been executed. 

Schedule a Report to Run via a Cron Job

To generate a report to run for a specific date/time, please refer to the Report chapter for further details.