Forum Discussion
- RiaanBadenhorstLevel 6
You can get it from opscenter custom query if you have opscenter analytics version. You can also get it from bpbdjobs for as long as its in the activity monitor.
Which one would you like?
- smith_jonesLevel 6
Hi Riaan,
The KEEP_JOBS_HOURS and KEEP_JOBS_SUCCESSFUL_HOURS are both set for one week. So I cannot fetch required from bpdbjobs.
Before posting this question I tried to use custom option on the Ops-Center but it just gave me the graphical and tabular data about how many hours the duplication ran but not the end times of each duplication job.
- RiaanBadenhorstLevel 6
What else do you want to see regarding these duplication jobs?
Run this to see what else you'd like to pull from domain_jobarchive
select * from domain_jobarchive
where domain_jobarchive.type in (4)
- smith_jonesLevel 6
Hi Riaan,
My requirement is I want the duration time each duplication job runs for.So that I can proceed to schedule further backups accordingly.
Can u please be more specific about the command? How I have to run this, what it is going to do?
Thanks.
- RiaanBadenhorstLevel 6
Hi,
You said you wanted the endtime, not the duration. Anyways, you can run this query in opscenter. Go to "reports" select "create report" and then select "SQL query"
Query below will show jobid, duration, start time, and end time of all duplication jobs
select
dja.id as "Job ID",
NOM_DateDiff(dja.startTime, dja.endTime) as "JobDuration",
dja.starttime as "Start time",
dja.endtime as "End time"
from domain_jobarchive dja
where domain_jobarchive.type in (4)
- smith_jonesLevel 6
Hi Riaan,
I told end time because I know the start time of each duplication backup. :)
By the way basically I need to know the time for which duplication ran.
AS per your suggestion I went to Ops-Center but was not able to proceed due to lack of knowledge -
Can u please guide? As I had proceeded with Backup Reports and did not get required result.
- RiaanBadenhorstLevel 6
Unfortunately, you don't have opscenter analytics (i asked about this in my first response). Without it you can't run SQL queries. Are you using per TB license on component? Its included with per TB.
- smith_jonesLevel 6Ok leave opscenter. No way from just Netbackup commands?
- RiaanBadenhorstLevel 6
bpdbjobs
- smith_jonesLevel 6
Hi,
There is no option that I can mention the date range in bpdbjobs command. I ran bpdbjobs -report (both all_columns and most_columns) and by default it gave me all the entries
but the count was according to KEEP_JOBS_HOURS or KEEP_JOBS_SUCCESSFUL_HOURS i.e. 8 days.
So basically what I learnt is bpdbjobs also depends upon KEEP_JOBS_HOURS or KEEP_JOBS_SUCCESSFUL_HOURS. Am I right?
Related Content
- 8 years ago
- 3 years ago
- 4 years ago