[Bacula-users] How to prevent duplicate copy jobs?

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?

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;"
}

------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises 
looking to deploy the next generation of Solaris that includes the latest 
innovations from Sun and the OpenSource community. Download a copy and 
enjoy capabilities such as Networking, Storage and Virtualization. 
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users