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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
