Forum Discussion

Cody_Cannefax's avatar
14 years ago
Solved

SQL Query for Backup Exec 12 to check backups

I need to have the ability to query SQL on Backup Exec 12 so that I can check progress (bytes written) of an active job.  I have found tables and views in History-type tables that actually show information regarding an active job but only shows a zero for TotalDataSizeBytes or for TotalRateMBMin.  These obbviously pull finished values if the job is complete but surely this live data can be pulled for a realtime value right?

Does anyone know of a way to find active data numbers thru SQL so we can then query this data to send out job progress updates?

If you've done this before, I'd appreciate your input.  Thanks!

Cody

  • First of all, Symantec discourages anyone from querying the BEDB directly.  The structure of the the BEDB is never published and it can change anytime without notice.

    That said, I don't think there is a running number of bytes written that is kept in the BEDB.  Only the final number will be kept.  So what you want is impossible.

  • First of all, Symantec discourages anyone from querying the BEDB directly.  The structure of the the BEDB is never published and it can change anytime without notice.

    That said, I don't think there is a running number of bytes written that is kept in the BEDB.  Only the final number will be kept.  So what you want is impossible.

  • As recommended by PKh "Symantec discourages anyone from querying the BEDB directly" .

    And it is not possile to get the ifnormation about the live data wirtten . You may probably write a script , using the bemcmd command line to get the the backup job status.

    Please check the link below

    http://www.symantec.com/docs/TECH126925

     

    Job Status Code Description

    JOB_STATE_CANCELED = 1 The job has been terminated because it was canceled.

    JOB_STATE_COMPLETED = 2 The job has completed and is waiting for final disposition.

    JOB_STATE_SUCCESS_WITH_EXCEPTION S = 3 The job has completed successfully with some exceptions.

    JOB_STATE_DISPATCHED = 4 The job has been dispatched.

    JOB_STATE_HOLD = 5 The job is on hold.

    JOB_STATE_ERROR = 6 The job has completed with an error.

    JOB_STATE_INVALID SCHEDULE = 7 The schedule for the task is invalid. The job will never run.

    JOB_STATE_NOT_IN_WINDOW = 10 The job's scheduled time window closed before the job could be dispatched. There may not have been an available device during the time window.

    JOB_STATE_READY_BUT_PAUSED = 11 The job is ready, but the media server is paused.

    JOB_STATE_PENDING = 12 The job is in a transitional state.

    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. The job history log has been marked JOB_STATE_RECOVERED, and the job has been scheduled to restart immediately

    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_RESUMED, the job has been scheduled to restart immediately, and the job flag has been set to indicate checkpoint restart.

    JOB_STATE_ACTIVE = 16 The job is currently running on the server.

    JOB_STATE_READY = 17 The job is eligible for dispatch.

    JOB_STATE_SCHEDULED = 18 The job has a due date in the future.

    JOB_STATE_SUCCESS = 19 The job has been completed successfully.

    JOB_STATE_SUPERCEDED = 20 The job is ready, but another higher precedence task is eligible to run.

    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_TO_BE_SCHEDULED = 22 The job needs to have the due date calculated.

    JOB_STATE_LINKED_JOB = 23 The job is linked to another job, and will not start until that job is finished

  • BEMCMD might be an option.  It's surprising they don't offer something that can do this.  Albeit lazy, I really don't want have to open the GUI on my off days to monitor backups and would be nice to get realtime numbers over email.

    Thanks again for your input.

  • Well you can post an Idea , requesting any such kind of enhancement , and if many people vote on it symantec enginerring team might take that up and probably get enhancement in the upcoming build .