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 start using Copy jobs but didn't want to > copy the whole pool as it was quite large.
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. One other option I forgot about in my last post: You can set the 'MaximumSpawnedJobs = n' in the new Copy job. Then, when it is run, it will take the first job and copy it while spawning n-1 additional copy Control jobs. Then, instead of doing what I said about setting a SQL query for some time frame and keep manually adjusting it up to today's date, this Copy job can then use the 'PoolUncopiedJobs' feature from the start, and just be run over and over to get all the jobs that have not been copied, without overwhelming the system with copy control jobs for every job in the pool all at once. :) It does not even need to be manual... Just set 'n' to some number larger than the number of expected nightly backup jobs to this pool, let it run each night on a normal schedule, and after some time it will finally catch up. :) Best regards, Bill -- Bill Arlofski w...@protonmail.com _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
