Hi,
I am using the following job to copy Full backups from disk to tape.
How would I set up duplicate job control, or change my sql statement, to
keep a subsequent running of the copy job from queueing more of the same
already queued copy jobs? For example, If I were to run this copy job,
and then immediately run it again.
Here is my current Job. I got the SQL statement from 'migrate.c'
Job {
Name = Copy_Full_D2T
Type = Copy
Schedule = D2T_Copy_Full
Client = None
File Set = None
Pool = Disk-Full
Messages = Standard
Maximum Concurrent Jobs = 1
Priority = 98
Write Bootstrap = "/opt/bacula/bsr/%i-%j.bsr"
Allow Duplicate Jobs = ??
Allow Higher Duplicates = ??
Cancel Queued Duplicates = ??
Cancel Running Duplicates = ??
Selection Type = SQLQuery
Selection Pattern = "SELECT DISTINCT Job.JobId,Job.StartTime FROM
Job,Pool WHERE Pool.Name = 'Disk-Full' AND Pool.PoolId = Job.PoolId AND
Job.Type = 'B' AND Job.JobStatus IN ('T','W') AND Job.jobBytes > 0 AND
Job.JobId NOT IN (SELECT PriorJobId FROM Job WHERE Type IN ('B','C') AND
Job.JobStatus IN ('T','W') AND PriorJobId != 0) ORDER by Job.StartTime;"
}
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
