- Code: Select all
exec master..sqbdata 'SELECT * FROM backupfiles_copylist where status <> ''s'' order by lastattempt desc'
one of the columns I get back is 'status'. I'm guessing that:
'S' is 'Success' (applied when the copy has succeeded),
'E' is 'Error' (applied after the copy job gives up),
'P' is 'Pending' (applied when the job is queued up but has run yet)
but there seem to be a few others.
What are the possible values, and what do they all mean?