Tried that, unfortunately, for some reason the DISK-TO-TAPE backup (using COPY)
shows NO JOBS to copy. I had it as a priority 95 but the query apparently runs
and since the current jobs are queued but not completed, it either shows NO
JOBS or only a couple of jobs that have finished. Here is the query:
job {
Name = Disk-to-Tape
JobDefs = Default-Disk-to-Tape-Job
Priority = 95
Selection Type = SQLQuery
Selection Pattern = "SELECT J.JobId
FROM Job J, Pool P
WHERE P.Name IN ('Daily-Incr','Weekly-Diff','Monthly-Full')
AND P.PoolId = J.PoolId
AND J.Type = 'B'
AND J.JobStatus IN ('T','W')
AND J.StartTime >= NOW() - INTERVAL '3 DAYS'
AND J.JobBytes > 0
AND J.JobId NOT IN
(SELECT PriorJobId
FROM Job
WHERE Type IN ('B','C')
AND Job.JobStatus IN ('T','W')
AND PriorJobId != 0)
ORDER BY J.JobId;"
Steven Hammond
I.T. Manager
Technical Chemical Company
For support, please email us at support AT technicalchemical DOT com.
-----Original Message-----
From: Uwe Schuerkamp [mailto:uwe.schuerkamp AT nionex DOT net]
Sent: Tuesday, February 18, 2014 9:28 AM
To: Steven Hammond
Cc: bacula-users AT lists.sourceforge DOT net
Subject: Re: [Bacula-users] Kicking off a job
On Tue, Feb 18, 2014 at 03:13:27PM +0000, Steven Hammond wrote:
> Here is the scenario. We kick off a daily DISK-TO-DISK backup at 18:00. We
> then kick off a DISK-TO-TAPE Backup (COPY) at 23:59 assuming the early job is
> finished. This works for the daily incrementals, but the differentials and
> full backups take longer. Yes, I could change the schedule for the
> DISK-TO-TAPE backup but I was wondering if it is possible, somehow, to kick
> off the DISK-TO-TAPE after the last job in the DISK-TO-DISK backup is
> complete (the catalog backup)? I assume it would be in the RunAfterJob on
> the catalog backup job, but I'm not for sure how to kick it off. Any
> suggestions would be appreciated.
>
> Steven Hammond
> I.T. Manager
> Technical Chemical Company
>
Hi Steven,
you could use different job prios to ensure the (lower priority)
d2t-Jobs starts off only when all other higher-prio jobs are finished.
Uwe
--
NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|