> > 
> > :List all Jobs needed for a disaster recovery for a jobname:
> > *Enter Job name:
> > SELECT DISTINCT Job.JobId,StartTime FROM Job  WHERE 
> Job.Name = '%1' AND (
> >   (Level='F' AND JobStatus IN ('T', 'W') AND
> >     Job.StartTime >= (
> >       SELECT DISTINCT StartTime
> >       FROM Job
> >       WHERE Job.Name = '%1'
> >       AND Level='F' AND JobStatus IN ('T', 'W') ORDER BY 
> StartTime DESC LIMIT 1
> >     )
> >   ) OR
> >   (Level='D' AND JobStatus IN ('T', 'W') AND
> >     Job.StartTime >= (
> >       SELECT DISTINCT StartTime
> >       FROM Job
> >       WHERE Job.Name = '%1'
> >       AND Level='F' AND JobStatus IN ('T', 'W') ORDER BY 
> StartTime DESC LIMIT 1
> >     )
> >   ) OR
> >   (Level='I' AND JobStatus IN ('T', 'W') AND
> >     Job.StartTime >= (
> >       SELECT DISTINCT StartTime
> >       FROM Job
> >       WHERE Job.Name = '%1'
> >       AND Level='D' AND JobStatus IN ('T', 'W') AND
> >       Job.StartTime >= (
> >         SELECT DISTINCT StartTime
> >         FROM Job
> >         WHERE Job.Name = '%1'
> >         AND Level='F' AND JobStatus IN ('T', 'W') ORDER BY 
> StartTime DESC LIMIT 1
> >       )
> >     ORDER BY StartTime DESC LIMIT 1 )
> >   )
> > ) ORDER BY JobId;
> > 
> 
> Hi Christian,
> 
> thanks for sharing, I'm glad the query.sql got you on your way. If you
> manage to "shoe-horn" a client or job name dynamically into a copy job
> definition then please let me know ;)
> 

Hi Uwe,

yes, it would be fine to get the job name dynamically into this definition :)

But... if I try the above SQL in a copy job's "Selection Pattern", it failes
because of a too small buffer (when I'm right, the buffer is "only" 500 chars).

So next I tried to put the statement above in a stored procedure in my database
and use "call my-procedure(my-jobname);" in Selection Pattern.  This at least 
gets the correct job ids for my copy job but the whole job failes with lots of
database related error messages like:

> 14-Feb 09:40 atpcc7fc-dir JobId 0: Fatal error: sql_create.c:517 
> sql_create.c:517 
> query SELECT ClientId,Uname FROM Client WHERE Name='atvies2gfx-fd' failed:
> Commands out of sync; you can't run this command now

Any idea what's going on here?

And now, as a last try I defined a view within my database with the above
statement, use "select JobId from my-view;" and.... Heureka!!! ... it's 
working!!

So... some questions left:
- can the size of "Selection Pattern" be increased (probably without increasing
  it for all other parameter values) ?
- why are stored procedures not possible in this case?

Thanks,
Christian

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users