Enable and schedule the Automated Offline SQL job

When the Automated Offline job runs, it pulls the .TRN files from the offline folder location defined in the system-level parameter Offline (Automated): Directory where offline TRN files are stored.

To enable and schedule the Automated Offline SQL job:

Note:
You can also run this job manually.

1. Create the server credential and proxy that allow the Automated Offline SQL job to access the designated offline workstations and pull the transaction files from them:

   Note:
   You can use any name for the credential and proxy.

   1. Create the credential - The credential account must be a domain account that has access to the domain workstations from which the job will pull the offline circulation transactions (.TRN files).
   2. Create the proxy that associates the credential with the job under Operating System (CmdExec).

      

2. Ensure that the System-level Offline (Automated): Enable automatic offline uploading parameter is set to Yes. See also: Set up Offline (Automated) Parameters.
3. Schedule the Automated Offline SQL job. No default schedule is specified. You can also run the job manually.

   When the job runs, it finds the .TRN files that are stored on the workstations in the directory specified in the parameter Offline (Automated): Directory where offline TRN files are stored. It then pulls these files from the workstations to the server, uploads the transactions into the Polaris database, renames the .TRN files with a .DON extension, and logs the results of the upload.

   Note:
   If no .TRN files are found, the SQL job history includes the message: There were no TRN files copied.