On 06/15/2012 03:43 AM, Uwe Schuerkamp wrote:
> On Thu, Jun 14, 2012 at 09:41:21PM +0200, Georges wrote:
>> Le 14/06/2012 13:00, Uwe Schuerkamp a écrit :
>>> Hi folks,
>>>
>>> I was wondering how bacula decides wether a job has already been
>>> copied to the next pool when using the PoolUncopiedJobs selection
>>> method. Can someone shed any light on this?
>> Well, the directive name seems to be clear enough ;-) All of uncopied jobs.
>>
>>
>> G.
> Agreed, but I was wondering *how* bacula determines wether a job has
> been copied or not. Do we check for pool residency, is it a flag in
> the Job DB table or something else entirely?
>
> All the best&  thanks for your help,
>
> Uwe
>
>
Hello Uwe,

I have a query in my query list to show uncopied jobs by pool name in 
bconsole.  Here it is:

:List Uncopied Jobs for Pool:
*Enter Source Pool Name :
SELECT DISTINCT 
Job.JobId,Job.Name,Job.level,Job.jobstatus,Job.StartTime,Job.EndTime,Job.jobfiles,Job.jobbytes
 

FROM Job,Pool
WHERE Pool.Name = '%1'
  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;

Hope that helps.

Regards,
Marty


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users