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.
Configuration
The application must be in production to send via SFTP. User Job Execution must be enabled in Application Configuration.
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 Schedule entered when scheduling. Once the Audit Job is set up, it will appear in the Job Scheduler with a Next Run date and time.
- Navigate to the Utilities menu > Job Scheduler.
- Click at the top of the grid. This will open a pop up window with the options to schedule the Job.
- Select the Job Type from the drop down.
- District Audit Job: class class org.ssdt_ohio.usas.reporting.audit.DistrictAuditJob
- SOC1 Audit Job: class org.ssdt_ohio.usas.reporting.audit.SOC1AuditJob
- Enter a Cron Schedule.
The Cron Schedule is where the Cron Expression will be entered to schedule the job. The Cron Schedule represents the frequency at which the job should run.
Cron Expression
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:
- Click to schedule the Job. This Submit button will not be available until the Job Type and Cron Schedule are populated.
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.
File Names
The SSDT USAS Auditor Extract (5) reports will use the following filename: "SCHOOL IRN_FY_USAS_TIMESTAMP.ZIP"
- Example "999999_2022_USAS_ 2022-07-01-120001.ZIP”
The SSDT SOC1 Audit Report Bundle (3) reports will use following filename: "SCHOOL IRN_FY_SOC-USAS_TIMESTAMP.ZIP”
- Example: “999999_2022_SOC-USAS_ 2022-07-01-120001.ZIP”
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.