Scheduling the Process Scheduler in Windows Scheduler

The Process Scheduler Schedule can either be run by clicking on the "Run" button  within the Process Scheduler Schedules screen within Sage 300 or it can be scheduled through the Windows Scheduler.

When using Windows Task Scheduler, the tasks run completely unattended. This is useful if you know exactly when you want to run the processes.

Example: You want to run the day end daily at 10 pm in all companies after all your branches have completed their operations.

Setup Overview

The program to be scheduled is located in the Sage 300 Programs directory under the OZXXA sub-directory and is called OZProcessScheduler.exe.

i.e. ..\OZxxA\OZProcessScheduler.exe (i.e. OZ73A\OZProcessScheduler.exe for version 2026)

Note: In earlier versions of Sage 300 prior to version 2022, the scheduler was called OZIntegrityCheck.exe.

You need to determine the schedule frequency depending on your business requirements.

To configure Windows Task Scheduler, you need to logon to the server with a user with admin rights for the setup. You also need a service account and password to save in the task. See details below.

Note: You can also schedule the OZProcessScheduler.exe program with other scheduler that are in use in your organisation.

User Account Note:

When scheduling using the Windows Scheduler, ensure the account under which the schedule is going to run has

  • Access to Sage 300
  • Use UNC path in the schedules to avoid drive mappings issues. If you are not using UNC Path, the user needs to have the same drive mappings as have been used in schedules.
  • Access to the drives referred to as part of the schedules (for example a Dump – the account will need write access to the dump folder)
  • The account will need read/write to the ..\Sage\SITE folder in order to connect to the Sage 300 company.
  • Ensure you use a network user with a password that does not expire. If you need to reset the password periodically, you will need to maintain the passwords here too.

Important! If the Windows Task Scheduler is being used on a machine where the Sage 300 programs have not been installed, then you need to do a Sage 300 workstation setup on the machine before the scheduled tasks will run.

Tip: To create a log file when running Schedules, See "Creating a log file with Process Scheduler"

Windows Scheduler Error Status Codes

Process Scheduler Integrity Check returns the following error status codes in the windows scheduler > Task Scheduler Library > Last Run Result.

OZProcessScheduler.exe returns different values on error:

• 0 = no error (schedule run ok)

• 101 (0x65) = cannot open session - check username and password in Options

• 102 (0x66) = schedule does not exist or subscription expired

• 103 (0x67) = cannot open database - check username and password in Companies

The last run result of the scheduled task shows the status of the last time this particular scheduled task ran.