Please perform the steps in sequential order in Home > Reports and Jobs > Jobs > Scheduled Jobs
Step 1 - Take the load off the job scheduler
- Filter for Job Status = 'Waiting'
- Select the 'Waiting' jobs and click the 'Pause' button.
- Filter for Job Status = 'Scheduled'
- Select the 'Scheduled' jobs and click the 'Pause' button.
- Filter for Job Status = 'Cancelled'
- Make a note of the schedule, as the job will need to be re-entered at a later time. A job in the 'Cancelled' status cannot be resumed, therefore will need to be deleted.\Delete all the 'Cancelled' instances of the following jobs:
- Time Slicing
- Post Timesheets
- Rate Matrix Extraction
- Investment Allocation
- Datamart Extraction/Datamart Rollup
- Load DWH
- Refresh Data Warehouse OData Model (for SaaS customers)
Step 2 - Cancel all jobs in the 'Processing' state.
- Filter for Job Status = 'Processing'
- Cancel the job(s).
Step 3 - Run an immediate instance of the Clean User Sessions job.
- This is to tell if the job scheduler is working correctly.
- The status should go to 'Processing'.
- If it does go to the 'Processing' state, allow the job time to complete. It should take less than 5 minutes to complete.
- If the job does not go into the 'Processing' state, please contact Support for an analysis.
- Once the immediate jobs are running:
- Select all the 'PAUSED' jobs and set them to 'Resume' to let it get back to the normal schedule.
- Re-enter the previously cancelled jobs in Step 1.
- If job runtime has increased for one or jobs after migration to a different database, the DBA team will need to perform analysis to get the runtime down to where it was prior to the migration.
- If a job fails, a subsequent run of the job should result in a completion. By design, the data is rolled back so that prior data is intact.
TIP: Ahead of an upgrade or patch install, the job scheduler should be in a no-load state which will prevent orphan jobs, database sequencing issues, and out-of-sync job starts.
- After the planned outage completes, the following can be performed on the Reports and Jobs > Scheduled page, after the BG service(s) are started.
- Run an immediate Time Slicing job to ensure it completes.
- Check the Administration > Time Slices page to ensure the 'Last Run' date reflects the most current time.
- Checkmark all PAUSED jobs and click the RESUME button. The jobs will be autoscheduled.
- These steps will ensure a smooth job scheduler startup as it will prevent jobs from getting stuck in the 'Processing', 'Waiting', and 'Scheduled' states.
- If a job that is in any of the following status: Scheduled, Waiting, Processing and set to Cancelled, the job instance scheduled effectively has to be rescheduled, as a cancelled job cannot be resumed.