Forum Discussion

Willie_SA's avatar
Willie_SA
Level 6
12 years ago

Ops Centre 7.5 report on active jobs - Hourly progress

We have jobs running for many hours backing up many Mb of data. One is a large Exchange backup.

Can Ops Centre report on ACTIVE jobs?

Can we setup an hourly report (Automated) in Ops Centre that will show the progress of the job or stream per mail on an hourly basis?

What Data Collection needs to be in place, and at what intervals to achieve this?

Do we require OC Analytics?

Backup and Recovery
OpsCenter
Windows Server (2003-2008)
  • tom_sprouse's avatar
    tom_sprouse
    12 years ago

    Wilie_SA

    I have a Custom SQL that will work to report Active Jobs... however, It would require analytics to run.

    I have included some common fields that may be useful for recieving this data hourly.
    SELECT   id AS "Job ID",
         clientname AS "Client",
         utcbiginttonomtime(starttime) AS "Start Time",
         filesbackedup AS "File Count",
         byteswritten/1024 AS "KByte Count",
         throughput AS "ThroughPut",
         attemptcount AS "Attempt #",
         policyname AS "Policy",
         schedulename AS "Schedule Name"

FROM domain_job 
WHERE state = 1

     

    There is a canned report, under workload analyzer called, Job Count WorkLoad Analyzer, that will provide a 'heat map' of the number of jobs active per 4 hours.... The number of jobs per range is adjustable. Please execute the report and let me know if that is what you are looking for.

     

    --Tom

     

  • Willie_SA's avatar
    Willie_SA
    Level 6
    12 years ago

    I am looking at creating these reports BUT it seems to me you cannot create reports of an ACTIVE job.

    Which report will give me the progress of a running job - per hour.

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    12 years ago

    Wilie_SA

    I have a Custom SQL that will work to report Active Jobs... however, It would require analytics to run.

    I have included some common fields that may be useful for recieving this data hourly.
    SELECT   id AS "Job ID",
         clientname AS "Client",
         utcbiginttonomtime(starttime) AS "Start Time",
         filesbackedup AS "File Count",
         byteswritten/1024 AS "KByte Count",
         throughput AS "ThroughPut",
         attemptcount AS "Attempt #",
         policyname AS "Policy",
         schedulename AS "Schedule Name"

FROM domain_job 
WHERE state = 1

     

    There is a canned report, under workload analyzer called, Job Count WorkLoad Analyzer, that will provide a 'heat map' of the number of jobs active per 4 hours.... The number of jobs per range is adjustable. Please execute the report and let me know if that is what you are looking for.

     

    --Tom

     

  • Willie_SA's avatar
    Willie_SA
    Level 6
    12 years ago

    Tom,

     

    This SQL procedure did exactly what I wanted. I even added a clie nt name, and now I can report on a specifief client.

    Now I am just going to schedule this to run every hour. Seems to me you need to build a schedule for every hour AS the reoccurance can only be done on a daily basis.

    Thank you very very much.

     

    TX

    WN

     

     

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    12 years ago

    Willie,

    If this resolves the issue, could you please mark the appropriate post as the solution.

    Thank you,

    --Tom