abort a job in progress
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).
Software Engineer / DBA
RenWeb School Management Software