Job Scheduler: Schedule

Schedule

The Schedule screen displays details of all the stored jobs. Use this screen to review job executions, errors and statuses.

Header Filters

• Job ID (Num) — Locate a specific gbschedulerjobs entry
• Show all Children (Check Box) — Check this to see all the child jobs of the filtered job. Visit the Parent Job ID page for all the details feature details.
• Module (List box) — Module category from gbschedulertypes
• Class (List box) — Class category from gbschedulertypes
• Method (List box) — Web service to execute
• Last Run (Date) — Jobs that have executed after the selected date
• Last Run Status (List Box) — Jobs with a specific lastrunstatus
• Next Run (Date) — Jobs scheduled to execute after the selected date
• Status (List Box) — 'Active' denotes a job that is scheduled to run. 'Inactive' jobs are not scheduled. 'Aborted' indicates a system failure. Contact Catch-e Support to investigate.
• (Button) — Click to execute your chosen filtering. If the button is disabled, then the current filtering has been executed.

Displayed Columns

• Job ID (Num) — Displays the "Job ID" which also hyperlinks you to the Scheduler / Job tab for the selected job.
• Parent ID — If the job is a child, it's parent id will be displayed here. Visit the Parent Job ID page for all the details feature details.
• Type — Displays a summary of the Module, Class and Method that apply to this job.
• Description — The users stored description of the job.

Last Run

• Last Run Status — Displays the status of the last run of this job. The status is 'Completed' if the job ran successfully and 'Failed' if it did not complete for some reason.
• Last Message — Displays the message that was generated when the job was last run. These mostly describe job failures or the reasons why a completed job did not generate a report or update as expected. Go to the Message page for a list of messages and explanatory comments.
• Next Run — The scheduled start date and time for the next run of this job.
• Status — Displays the current job status of the job. 'Active' jobs will run when their scheduler run time is reached, 'Inactive' jobs will not run.

Troubleshooting

Tip: Visit the main Troubleshooting page for a list of all the available problem-solving tips.

My Attachment Formatting did not work

If your scheduler job is using 'Office(xlsx))' as the "Mail Attachment", you cannot use a customisedFormat#customised-spreadsheet-formats) format.Go to the Scheduler / Job and change the output format to be 'Office(xls)'Format) if you want to create and use a customised_Format#customised-spreadsheet-formats) format.

Schedule Troubleshooting

My job is inactive

If a job is inactive, and there is no audit record of this, check to see if the job is attached to a parent job.

If a a parent job is made inactive, the child jobs are also made inactive.

Handy hint: If you need to update a chain of jobs to make them active again, do the following

1. Find the Parent Job on the Scheduler / Schedule tab
2. ** Show all Children** check this on
3. Job ID - find and hyperlink to the last job in the chain
4. Edit this job
5. Parent Job ID - select and hyperlink to the parent
6. Continue until you are back and the original job
7. Recheck all jobs in the chain again to confirm

My job is active but does not run

If a job is active, and is not a child job, the Run Times settings may be counteracting each other.

1. If a job should run on a certain day of the week, e.g. every Wednesday
2. Days: should be checked ON.
3. Months: should be checked ON.
4. Weekdays: should be un-checked and should contain selections. E.g. Wed
5. If a job should run on a certain date/s in the month, e.g. 15th of each month
6. Days: should be un-checked and should contain selection. E.g. 15ths
7. Months: should be checked ON.
8. Weekdays: should be checked ON.
9. If a job should run on a certain date in a month or selected months. E.g. 1st July each year
10. Days: should be un-checked and should contain selections. E.g. 1st
11. Months: should be un-checked and should contain selections. E.g. July
12. Weekdays: should be checked ON.

My job has failed

Find and review the failed job on the Scheduler / Schedule tab. The "Last Message" often contains a message about the failure.

Visit the Message page for a list of these messages and explanatory comments that may help you diagnose the problem.

Fleet Management Scheduler Jobs

The scheduler jobs below are the recommended base set for Fleet Management clients.

The Job ID and Query ID's shown are for our Demo environment and will be different in your system.

The name of each job will be the same, unless changed.

Maintenance Transaction Upload

The Update Maintenance process enables you to Import Table Data and process the transactions into the table in bulk.

The Scheduler Jobs below run to update the data and send a confirmation.

• 10063 (executeScript) — Contracts - Maintenance - Post uploaded transactions Run timing: Daily. 5pm EST Open Update Maintenance for details of uploading bulk maintenance transactions. 100195
• 10064 (executeQuery) — Contracts - Maintenance - Post uploaded transactions confirmation Confirmation of loaded transactions. 100196 10063

Car Claims

Use the suite of jobs below to automate the processing of claims submitted by drivers and employees for car reimbursement claims.

Insurance Annual

The jobs below are used to update comprehensive insurance pricing each year or when a pricing change occurs.

Visit the Insurance Annual page for more details of these jobs and the process to follow.

Exceptions

| | | | executeQuery | Contract Billing Date Checks Run Time: Weekdays 5:05am Delivery Type: Email

Purpose:
List novated contracts where there are pending billing records that are not aligned with the client's stored "Payroll Date".
Use this list to update the contract billing dates as required. |

Ad Hoc

| | 100233 | | executeQuery | Lease Transfer Report Run Time: Ad Hoc Delivery Type: Report Queue

Purpose:
List contracts where leases are being transferred to another lease provider.
Basic contract and payment information is shown.
Report can be modified to select by client and or channel
Report is designed to use a last day 'DATE' to select and report on contract billings and payments required to be processed by the new provider. |

Make a job active

Qualifiers

1. You want to make a job active so it will run automatically

Process

1. Find the job
2. Navigate to the Scheduler / Job tab
3. Click on **
4. Status - update to 'active'
5. Click on **

Make a job inactive

Qualifiers

1. You want to make a job inactive so it will not run automatically

Process

1. Find the job
2. Navigate to the Scheduler / Job tab
3. Click on **
4. Status - update to 'inactive'
5. Click on **

Run a job

Qualifiers

1. You want run a job manually or
2. You are testing a executeQuery, executeScript or mailQuery job in Staging

Process

1. Go to the System / Scheduler menu
2. Navigate to Scheduler / Job
3. Job ID - enter the ID
4. Tab out of this field
5. Click on [Run Now]

Create an executeQuery job

Qualifiers

1. You want to create an executeQuery) job
2. A suitable query exists or has been created.

Process

1. Navigate to the Scheduler / Job tab
2. Click on **
3. Job Type
4. Module - 'gb
5. Çlass - 'queries
6. Method - 'executeQuery'
7. Parameters
8. Query ID - enter or lookup the query you will use
9. Run Times
10. If the fields below are greyed out, this means the job is a child of another job. The parent job controls the run times. The run times must be updated in the parent job.
11. Minutes: - click on the minute, minutes or range of minutes you want the job to run on
12. E.g. choosing 0, 15, 30, 45 would run the job every 15 minutes for the selected run hours.
13. 'All' is not a recommended setting.
14. Hours: - click on the hour, hours or range of hours you want the job to run on.
15. E.g. choosing 6am-9pm would run the job every 15 minutes from 6:00am to 9:45pm
16. Days: - click on the days you want the job to run on.
17. Choose 'All' to run the job on any day.
18. Months: - click on the months you want the job to run on.
19. Choose 'All' to run the job in any month.
20. Weekdays: - click on the specify days you want the job to run on.
21. Monday - Friday is a popular choice for business process jobs and emails.
22. Delivery Method - choose from either Send Mail or Report Queue
23. Catch-e recommends using the report queue for regular reports to internal staff for better security
24. Send Mail (if checked)
25. Subject - enter the email subject
26. Body - enter the email body
27. To add recipients
28. Recipients: Type - choose from 'to', 'cc' or 'bcc'
29. Recipients: Name - enter the name
30. Recipients: Address - enter the email address
31. Repeat for each recipient you want to add
32. Report Queue (if checked)
33. Recipients: User - enter or lookup a user record
34. Recipients: Name - will populate from selected user record
35. Recipients: Address - will populate from selected user record
36. Recipients: Notify - un-check if email advice is not required.
37. Repeat for each recipient you want to add
38. Click on **

UAT an executeQuery job

Qualifiers

1. You are testing a executeQuery job in Staging.

Go to the job

1. Go to System / Scheduler
2. Navigate to Scheduler / Job
3. Job ID - enter the ID
4. Enter or tab out of this field

Use the Report Queue

If the job is set-up to email, speed up your testing process by changing the job to use the Report Queue.

Emails will only send from the Live environment and will not send from Staging.

1. Click on **
2. Report Queue - check
3. Alert Message: Selecting "Report Queue" will disabled "Send Mail" and remove all linked recipeints. Do you want to continue?
4. Click on **
5. Recipients: User - enter or lookup your user record (Name and Address will populate)
6. Recipients: Notify - un-check
7. Click on **

Run the job and get the report

1. Click on [Run Now]
2. Alert Message: Job completed OK!
3. Click on **
4. Go to System / Report Queue
5. Download your report

Find a job

Qualifiers

1. You want to find a job so you can edit it or run it

Find the job

1. Go to System / Scheduler
2. Limit the records you need to search on by filtering as follows
3. Module - select
4. Class - select
5. Method - select
6. Status - select 'Active'
7. Click on Type and Description to dynamically sort date to search for the job.
8. Job ID - click on the hyperlink of the job

Go to the job

1. Go to System / Scheduler
2. Navigate to Scheduler / Job
3. Job ID - enter the ID
4. Enter or tab out of this field