Bacula-users

Re: [Bacula-users] Questions on Copy Jobs

2009-12-10 14:14:03
Subject: Re: [Bacula-users] Questions on Copy Jobs
From: Mingus Dew <shon.stephens AT gmail DOT com>
To: Brian Debelius <bdebelius AT intelesyscorp DOT com>
Date: Thu, 10 Dec 2009 14:04:59 -0500
Thanks for the help. This got me going in just the right direction.

-Shon

On Tue, Oct 27, 2009 at 11:49 AM, Brian Debelius <bdebelius AT intelesyscorp DOT com> wrote:
The copy job copies all uncopied jobs one job at a time, one job at a time.  If you need to limit this, you need to use your own sql command.  I pulled the SQL statement from the source that does the selection for the uncopied jobs, and modified it with a date range, and run this to do uncopied jobs in batches when the need arises.

Watch for typos

SELECT DISTINCT    Job.JobId FROM Job,Pool WHERE Pool.Name = 'MyPoolName' AND Pool.PoolId = Job.PoolId AND Job.Type = 'B' AND Job.JobStatus IN ('T','W') AND Job.jobBytes > 0 AND (Job.StartTime > '2009-09-01 00:00:00' AND Job.StartTime < '2009-10-27 00:00:00') AND Job.JobId NOT IN (SELECT PriorJobId FROM Job WHERE Type IN ('B','C') AND Job.JobStatus IN ('T','W') AND PrioJobId != 0) ORDER by Job.StartTime;

Mingus Dew wrote:
In the documentation, there is an example for a Copy Job using the Selection Type "PoolUncopiedJobs". I'd like to implement Copy Jobs using this selection type. I currently have about 30 clients backed up into the same Disk Pool. There are 28 days of backups on Disk for each client.

If I setup a Copy Job like the one below, will it Copy all the previous Jobs in that Pool in one run? Is there a way to limit this?
If I use a SQLquery selection to Copy the previous 14 days, will the next Copy using PoolUncopiedJobs only copy the Jobs since then, or will it go back beyond as well?
For Pools like mine that contains many Jobs, will there only be 1 Copy Job Id or does it create and ID for each Job being copied?

#
# Default template for a CopyDiskToTape Job
#
JobDefs {
 Name = CopyDiskToTape

 Type = Copy
 Messages = StandardCopy
 Client = None
 FileSet = None
 Selection Type = PoolUncopiedJobs
 Maximum Concurrent Jobs = 10
 SpoolData = No
 Allow Duplicate Jobs = Yes
 Allow Higher Duplicates = No

 Cancel Queued Duplicates = No
 Cancel Running Duplicates = No
 Priority = 13
}

Schedule {
  Name = DaySchedule7:00
  Run = Level=Full daily at 7:00
}

Job {
 Name = CopyDiskToTapeFullBackups

 Enabled = Yes
 Schedule = DaySchedule7:00
 Pool = FullBackupsVirtualPool
 JobDefs = CopyDiskToTape
}
 
Thanks,
Shon
------------------------------------------------------------------------

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference

------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
 


------------------------------------------------------------------------------
Return on Information:
Google Enterprise Search pays you back
Get the facts.
http://p.sf.net/sfu/google-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>
  • Re: [Bacula-users] Questions on Copy Jobs, Mingus Dew <=