Re: [Bacula-users] Maximum Concurrent Jobs

Mark Gordon wrote:
>> No you are correct. Simultaneous jobs allow multiple jobs to use the
>> same storage device at the same time. Provided that only 1 pool is
>> involved because a single (non autochanger) storage device can only
>> load 1 volume at a time.
> 
>> John
> 
> So that's the sticking point. 1 volume at a time unless I want to dump 8
> clients into the same volume with no way to tell who is using what
> amount of storage space.

Take a look at query 14 in the standard build, then take a look at this:


#36
:List total tape consumption per job
  SELECT DISTINCT Job.Name as Name,
                 sum (Job.JobFiles) as Files,
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00),1)),8,' ') 
AS GB,
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00)/195,1)),5,' 
') AS "~LTO2",
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00)/1400,1)),5,' 
') AS "~LTO5"
#        sum (Job.JobBytes) as Bytes
  FROM Job
  WHERE Job.Type = 'B'
  AND Job.JobFiles > 0
  GROUP BY Job.Name,Job.type
  ORDER by Job.Name ;

SELECT          Count(Job.Name) as TOTAL_Jobs,
                 sum (Job.JobFiles) as Files,
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00),1)),8,' ') 
AS GB,
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00)/180,1)),5,' 
') AS "~LTO2",
 
lpad(text(round(sum(Job.JobBytes)/(1024.00*1024.00*1024.00)/1400,1)),5,' 
') AS "~LTO5"
  FROM Job
  WHERE Job.Type = 'B'
  AND Job.JobFiles > 0;

SELECT COUNT (media.name) as Actual_LTO2
         FROM Media
         WHERE media.mediatype = 'LTO-2';




------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users