
However, the ERP server the backups appear to be. JOB_STATE_TO_BE_SCHEDULED = 22 The job needs to have the due date calculated.So this new job of mine has a working backup solution in place in the main office on both the File/AD server and the ERP server. JOB_STATE_THRESHOLD_AUTO_ABORT =21 The job was canceled because it was not completed within the number of hours or minutes that were set for the Enable automatic cancellation option on the job schedule. JOB_STATE_SUPERCEDED = 20 The job is ready, but another higher precedence task is eligible to run. JOB_STATE_SUCCESS = 19 The job has been completed successfully. JOB_STATE_SCHEDULED = 18 The job has a due date in the future. JOB_STATE_READY = 17 The job is eligible for dispatch. JOB_STATE_ACTIVE = 16 The job is currently running on the server. The job history log has been marked JOB_STATE_RESUMED, the job has been scheduled to restart immediately, and the job flag has been set to indicate checkpoint restart. JOB_STATE_RESUMED = 15 During startup, Backup Exec detected that a job was active when the server was shut down, and that the Checkpoint restart option was enabled for this job. The job history log has been marked JOB_STATE_RECOVERED, and the job has been scheduled to restart immediately JOB_STATE_RECOVERED = 13 During startup, Backup Exec detected that a job was active when the server was shut down, and that the Checkpoint restart option was not enabled for this JOB_STATE_PENDING = 12 The job is in a transitional state. JOB_STATE_READY_BUT_PAUSED = 11 The job is ready, but the media server is paused. There may not have been an available device during the time window. JOB_STATE_NOT_IN_WINDOW = 10 The job's scheduled time window closed before the job could be dispatched.

JOB_STATE_INVALID SCHEDULE = 7 The schedule for the task is invalid.

JOB_STATE_ERROR = 6 The job has completed with an error. JOB_STATE_DISPATCHED = 4 The job has been dispatched.

JOB_STATE_SUCCESS_WITH_EXCEPTION S = 3 The job has completed successfully with some exceptions. JOB_STATE_COMPLETED = 2 The job has completed and is waiting for final disposition. JOB_STATE_CANCELED = 1 The job has been terminated because it was canceled. Within that database is a table called "vwJobHistory" and a field called 'Final Job Status'. I connected to the "\BKUPEXEC database and used the BEDB datafile. If you know of another way to connect to SQL, use it. I used Excel (of all things) to connect to the data using its data connection features.

Below you'll find a list of status codes for the "Final Job Status" field in the BEDB database.
