Re: [Bacula-users] PoolUncopiedJobs directive

[Marty F. <m.f...@es...>]

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