截屏视频帮助

Ops Centre 7.5 report on active jobs - Hourly progress

创建时间: 03 7 月 2013 • Updated: 09 7 月 2013 | 6 条评论
Willie_SA 的图片
此问题已解决。 请查看解决方案。

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?

讨论 归类至以下社区:

评论 条评论跳转至最新评论

Willie_SA 的图片

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 的图片

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

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

解决方案
Willie_SA 的图片

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 的图片

Willie,

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

Thank you,

--Tom

Note: If this post provides you with a solution don't forget to mark the discussion as solved...