Scheduled jobs fail but running manually works fine

Compresses, encrypts, secures and monitors SQL Server backups.

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

Scheduled jobs fail but running manually works fine

Postby marty_m » Wed Apr 16, 2014 10:39 pm

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.
marty_m
 
Posts: 2
Joined: Wed Apr 16, 2014 10:17 pm

Postby petey » Thu Apr 17, 2014 4:41 am

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
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby marty_m » Thu Apr 17, 2014 7:16 pm

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

Thanks!
marty_m
 
Posts: 2
Joined: Wed Apr 16, 2014 10:17 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 2 guests