Red Gate forums :: View topic - Copy job status codes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Copy job status codes

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
RichardRayJH



Joined: 21 Sep 2009
Posts: 13
Location: Teton Village, WY, USA

PostPosted: Wed Jul 17, 2013 7:10 pm    Post subject: Copy job status codes Reply with quote

When I run

Code:

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
Back to top
View user's profile Send private message Send e-mail
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Jul 18, 2013 7:21 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group