Here's an sql query I wrote to tell me which tapes that are in the autochanger
are in need of replacment:
-------------------------------------------
# 18
:List Volumes in the changer that are in need of replacement
SELECT VolumeName,Storage.Name AS Storage,Slot,Pool.Name AS
Pool,MediaType,VolStatus,VolErrors AS Errors
FROM Media,Pool,Storage
WHERE Media.PoolId=Pool.PoolId
AND Slot>0 AND InChanger=1
AND Media.StorageId=Storage.StorageId
AND ( (VolErrors>0) OR (VolStatus='Error') OR (VolMounts>50) OR
(VolStatus='Disabled') OR (VolWrites>3999999) OR (VolStatus='Full'))
ORDER BY Slot ASC, VolumeName;
-------------------------------------------
Now, I'd like to run this query automatically, as part of the BackupCatalog job.
My questions are:
how can I direct bacula to run a pre-defined SQL query?
can a job have multiple RunAfterJob directives, so that once the
BackupCatalog job is complete, the delete_catalog_backup script is
called, and then the SQL query is run
By the way, the sqlquery feature of bacula is terrific!
Mark
----
Mark Bergman [EMAIL PROTECTED]
System Administrator
Section of Biomedical Image Analysis 215-662-7310
Department of Radiology, University of Pennsylvania
http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu
The information contained in this e-mail message is intended only for the
personal and confidential use of the recipient(s) named above. If the reader of
this message is not the intended recipient or an agent responsible for
delivering it to the intended recipient, you are hereby notified that you have
received this document in error and that any review, dissemination,
distribution, or copying of this message is strictly prohibited. If you have
received this communication in error, please notify us immediately by e-mail,
and delete the original message.
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
