Hi, On 2/26/2007 3:32 PM, Jonas Wueste wrote: > Hi, > > I want to evaluate the number of currently queued jobs. At first I > wanted to do this with a mysql-query. (SELECT COUNT(*) from Job where > JobStatus ='C')
That's not the best solution, as the catalog doesn't necessarily represent the state of the currently running DIR. You already know that :-) > My Problem is that there are some old entries with the status "Created, > not yet running", wich shouldn't be deleted. > Is there an other possibility to get the number of queued jobs? > Currently I'm running Bacula Version: 2.0.1 Ask the DIR and count ;-) I'd use something like 'echo 'sta dir' | bconsole -c /etc/bacula/bconsole.conf' and some awk magic which I can't easily produce - I'm not really fluent in awk, but anyone with some experience with it will easily suggest an awk script to count the lines matching some RE. Example output from my system: 9025 Increme DracheStd.2007-02-26_08.20.00 is running 9032 Increme GoblinDB.2007-02-26_08.25.05 is waiting for higher priority jobs to finish 9033 Differe BackupMail.2007-02-26_08.30.01 is running 9034 Full BackupCatalog.2007-02-26_08.34.02 is waiting execution 9035 Shutdown.2007-02-26_09.00.00 has been canceled So, to find what's currently queued, you need lines matching '^.*is waiting.*$' hmm, no need for awk there (though that could make the query more robust) but grep is sufficient: echo 'sta dir' | bconsole -c /etc/bacula/bconsole.conf | grep -ce '^.*is waiting.*$' 2 Try that and see if it works for you! Arno > Greetings, > Jonas > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
