Red Gate forums :: View topic - Scheduled jobs fail but running manually works fine
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

Scheduled jobs fail but running manually works fine

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



Joined: 16 Apr 2014
Posts: 2

PostPosted: Wed Apr 16, 2014 10:39 pm    Post subject: Scheduled jobs fail but running manually works fine Reply with quote

Version: SQL Backup Pro 7.2.1.4
Backing up a non-clustered Microsoft SQL Server 2012

I can run manual backups fine but none of the scheduled backups on jobs run. The time comes to run and the job immediately says outcome Failed. Right-clicking on the job and pressing START yields the same result.

The manual backup job is identical to the scheduled one with the exception that it is scheduled.

Where do I start?

Thanks in advance for your help.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2305

PostPosted: Thu Apr 17, 2014 4:41 am    Post subject: Reply with quote

Check the account assigned to run the job, and that it has rights to run the sqlbackup extended stored procedure.
_________________
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
marty_m



Joined: 16 Apr 2014
Posts: 2

PostPosted: Thu Apr 17, 2014 7:16 pm    Post subject: Reply with quote

That was it. I checked in SSMS and I changed the job owner and BAM! Now it's working great.

Thanks!
Back to top
View user's profile Send private message
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