How can we help you today? How can we help you today?

Scheduled jobs fail but running manually works fine

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
0

Comments

2 comments

Sort by
  • petey
    Check the account assigned to run the job, and that it has rights to run the sqlbackup extended stored procedure.
    petey
    0
  • marty_m
    That was it. I checked in SSMS and I changed the job owner and BAM! Now it's working great.

    Thanks!
    marty_m
    0

Add comment

Please sign in to leave a comment.