Hi there, I've noticed that full backup jobs that are migrated are not considered as a Backup job. So I get the following message:
13-Jul 02:00 srv-backup03-dir: sql_find.c:134 No Job record found: ERR= CMD=SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND Level='F' AND Name='srv-erh01' AND ClientId=15 AND FileSetId=27 ORDER BY StartTime DESC LIMIT 1 However I've noticed that it works if I change the select statement to insert ( Type='B' or Type='M') so the statement above becomes: SELECT StartTime FROM Job WHERE JobStatus='T' AND ( Type='B' OR Type='M') AND Level='F' AND Name='srv-erh01' AND ClientId=15 AND FileSetId=27 ORDER BYStartTime DESC LIMIT 1; +---------------------+ | StartTime | +---------------------+ | 2007-07-19 02:29:33 | +---------------------+ As I am no bacula or SQL expert, have I understood the statement correctly? If so how does it get fixed on bacula? Thank you. Gustavo. -- "Nam et ipsa scientia potestas est" -- Sir Francis Bacon, 1597 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users