Thanks for the explanation Andrian.
In the meantime, I've given the 'PoolUncopiedJobs' option a go, and it appears
to work just as well as the SQL query that I originally included in my email.
However, Im still stuck in the loop mentioned earlier - I still appear to be
copying two jobs, then wh
On Mon, Jan 16, 2012 at 01:23:37PM +, Joe Nyland wrote:
> However, I am still unable to see what this query is doing :-(. If I run it
> against my catalogue DB, I just get a long list of JobIDs, which don't look
> right for my SVN_Full pool. I have a feeling I may be over complicating thigs
Hi,Thanks for your pointer Phil - it seems to be valid now.However, I am still unable to see what this query is doing :-(. If I run it against my catalogue DB, I just get a long list of JobIDs, which don't look right for my SVN_Full pool. I have a feeling I may be over complicating thigs using a SQ
On 01/15/2012 04:17 PM, Joe Nyland wrote:
> select a.JobId from Job AS a JOIN Pool AS b
> ON a.PoolId=b.PoolId AND b.Name!='ARCH'
> AND b.Name!='TAPE'
> WHERE a.Type='B' AND a.JobID NOT IN
>(SELECT PriorJobId FROM Job AS c JOIN Pool AS d
> ON c.PoolId=d.PoolId AN
Hi,
Thanks for you input.
Unfortunately, I am no SQL expert, and I get the following when trying to run
your selection query against my Bacula MySQL DB:
select a.JobId from Job AS a JOIN Pool AS b
ON a.PoolId=b.PoolId AND b.Name!='ARCH'
AND b.Name!='TAPE'
WHERE a.Type='B' AND a.JobID NOT IN
On Sat, Jan 14, 2012 at 11:46:21PM +, Joe Nyland wrote:
> I have a copy job as follows:
> Selection Type = SQLQuery
> Selection Pattern = "SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool
> WHERE Pool.Name = 'SVN_Full'
> AND Pool.PoolId = Job.PoolId
> AND Job.Type = '
Hi there,
Thanks for replying.
I had thought of doing it with a bash script like this, yes, but it seems
(According to
http://www.bacula.org/manuals/en/concepts/concepts/Migration_Copy.html) that
Bacula is capable of doing what I want. It is preferred to use Bacula for this
task, so that back
Why not just write a shell script to copy
the archive volumes and either run it as a
type=Admin job or from cron? That's
what I do. Have it set up so each
client has it's own pool of "use-once"
volumes with the date-time in the name.
Simple 'touch' and 'find -newer' commands
figure out what to co
