abort a job in progress

dhtucker

Is there any way to cancel or abort a backup job once it's launched?

I just started a "backup up every database on this server" job, only to discover the agent doesn't seem to have write privilege to the backup folder. So it's now slowly and methodically failing each database in turn, and I can't seem to find the off switch! Restarting the SQL Backup interface doesn't help, even restarting the SQL Backup Agent service doesn't seem to dissuade it - it just keeps plugging along (failing).

dhtucker

I thought maybe it'd stop if I deleted that server from the group.

Good news:
Yes, that stops a job in progress.

Bad news:
It also caused SQL Backup I/F to crash (invalid object reference)
and the SQL Backup Agent on that server stopped.

Not quite the solution I was looking for... :oops:

petey

There isn't a command to stop a backup task once it's been started. Next time, try closing the GUI, then stop the SQL Backup Agent service for a minute or so.