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?