From: Summers, James B. II <jsummers@ou...> - 2012-09-26 14:14:50
I need to build a list of my file storage volumes that contain a "full" backup. Which I will then take that list and use to make an offsite longterm archive.
I could not find a way to do it efficiently with the bls program, so I turned to using a sql script to do it. Here is what I have written:
from job, jobmedia
where level = 'F'
and name != 'BackupCatalog'
and name != 'RestoreFiles'
and job.jobid = jobmedia.jobid
order by jobmedia.mediaid
My volumes are actually named "VolXXXX" and the mediaid is an integer but it seems to sequence with what I am seeing in my email reports.
Does anyone know if the sql above is correct for what I am trying to get?
I would also only like to get the volumes where the job finished successfully. Looking at the jobstatus column in the job table, almost all are "T", but I did see two records that have an "E" in the jobstatus column.
Does anyone know the description of the codes for jobstatus?
Get latest updates about Open Source Projects, Conferences and News.