On Tue, Jan 14, 2014 at 02:17:12PM +0000, Steven Hammond wrote: > I've decided to write my on SQL QUERY to just copy jobs that haven't been > copied in the last 24 hours (disk to tape backup follows on the heels on the > disk to disk backup). I wanted to just keep the same JOB for disk to tape > copy but us a SQL QUERY instead of the PoolUncopiedJobs. But I need to use > the POOL name that is supplied in our SCHEDULE setup (incremental, > differential, full). Here is the query, but of course it doesn't work and I > was hoping someone could enlighten me on how to accomplish it. Thanks. > Dumb question: Why don't you select by JobLevel? Are you copying to separate pools?
All the best, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users