Copy job status codes

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Copy job status codes

Postby RichardRayJH » Wed Jul 17, 2013 7:10 pm

When I run

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?
-
Richard Ray
Jackson Hole Mountain Resort
Teton Village, WY
RichardRayJH
 
Posts: 13
Joined: Mon Sep 21, 2009 9:49 pm
Location: Teton Village, WY, USA

Postby petey » Thu Jul 18, 2013 7:21 am

A for active, meaning that the file is currently being copied.
C for cancelled, when the source file cannot be found, or when copying to the hosted storage is cancelled.

E for expired, which by default happens 24 hours after the file has been placed in the queue and could not be copied during that interval.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests