Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 48 Current »

If an employee has a job scheduled and then the user is Locked or Disabled, the Job scheduled will fail.


List of Reports and Direct Deposits scheduled to be run or delivered at a later 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.

To add more columns to your grid, click on 
  

Will show when a schedule job will begin running.

The job will show as a PENDING status:

.

Once the Job runs, will be change to COMPLETED:

The report will be sent to the address entered.

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. 

Configuration

The application must be in production to send via SFTP. User Job Execution must be enabled in Application Configuration.

For District and SOC1 reports,  it is looking at the previous fiscal year.  

For example:
If Current Period is in FY23, the report should have a date range of 7/1/21-6/30/22.


District Audit Job

The required permission to schedule DistrictAuditJob is USPS_STANDARD_AOS and MODULE_FILE_AUDITREPORT. (STANDARD and GROUP_MANAGER roles include these)

The District Audit Job runs the following reports:

  • AoS Employee Report 
  • AoS Payment History Report 
  • AoS Payment Distribution Report

Job Type: Job Type: class org.ssdt_ohio.usps.reporting.aos.DistrictAuditJob

SOC1 Audit Job

The required permission to schedule SOC1AuditJob is USPS_STANDARD_AOS and MODULE_FILE_AUDITREPORT.  (STANDARD and GROUP_MANAGER roles include these)

The SOC1 Audit Job runs the following reports:

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

Job Type: class org.ssdt_ohio.usps.reporting.aos.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 org.ssdt_ohio.usps.reporting.aos.DistrictAuditJob
    2. SOC1 Audit Job: class org.ssdt_ohio.usps.reporting.aos.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:

  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.

File Names

The SSDT USPS Auditor Extract reports will use the following filename: "SCHOOL IRN_FY_USPS_TIMESTAMP.ZIP"

  • Example "999999_2022_USPS_ 2022-07-01-120001.ZIP”

The SSDT SOC1 Audit Report Bundle reports will use following filename:  "SCHOOL IRN_FY_SOC-USPS_TIMESTAMP.ZIP”

  • Example: “999999_2022_SOC-USPS_ 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

The option, allows the users to create a "Job" that will run a report with the specified parameters on a schedule:

Enter in a Job Name:

To find the Cron Expression, go to http://www.cronmaker.com or https://www.freeformatter.com/cron-expression-generator-quartz.html 

  • Enter in the time desired and click on   Example:  Every day at a specific time, every month on the 12th, every week on Monday, every 3 hours, etc, etc.
  • Copy the Cron format  and enter in the Schedule Report - Cron Expression field:

Send output to: Enter an email address, FTP, URL or other destination address:

and click on 



  • No labels