Re: [Bacula-users] Job copy question

2022-02-25 Thread Josip Deanovic
On 2022-02-25 16:05, Marcelo Slon wrote: Hi, I have configured a copy job with the Selection Type = PoolUncopiedJobs directive. Is there a way to list the jobs that have not yet been copied before running this job in the console or by SQL query? Where is this information stored in the

[Bacula-users] Job copy question

2022-02-25 Thread Marcelo Slon
Hi, I have configured a copy job with the Selection Type = PoolUncopiedJobs directive. Is there a way to list the jobs that have not yet been copied before running this job in the console or by SQL query? Where is this information stored in the database? Thanks, Marcelo Slon

Re: [Bacula-users] Job copy question

2022-02-25 Thread Bill Arlofski via Bacula-users
On 2/25/22 15:59, Josip Deanovic wrote: > > Several years ago I posted to this list an SQL query that copies only > the jobs that weren't already copied, while starting from the last > successful Full job. The post could still be found in the mailinglist > archives. > > I used it when I had to

Re: [Bacula-users] Job copy question

2022-02-25 Thread Josip Deanovic
On 2022-02-25 23:01, Bill Arlofski via Bacula-users wrote: [...] When customers start doing copy jobs and want to use the convenient "PoolUncopiedJobs" feature, I usually recommend to start by using a series of SQL queries instead. The idea is to configure the Copy job to select jobs between

Re: [Bacula-users] Job copy question

2022-02-25 Thread Bill Arlofski via Bacula-users
On 2/25/22 08:05, Marcelo Slon wrote: > Hi, > > I have configured a copy job with the Selection Type = PoolUncopiedJobs > directive. > Is there a way to list the jobs that have not yet been copied before running > this job in the console or by SQL query? Where > is this information stored in the

Re: [Bacula-users] Job copy question

2022-02-25 Thread Josip Deanovic
On 2022-02-26 00:09, Bill Arlofski via Bacula-users wrote: Thanks Josip! I will go look for that post. Sounds like a useful SQL query for implementing Copy jobs when a history of other jobs already exists in a pool you'd like to copy from. I found it in my configurations. I think this is it.

Re: [Bacula-users] Job copy question

2022-02-25 Thread Phil Stracchino
On 2/25/22 17:59, Josip Deanovic wrote: Several years ago I posted to this list an SQL query that copies only the jobs that weren't already copied, while starting from the last successful Full job. The post could still be found in the mailinglist archives. I used it when I had to start using