Forum Discussion

Hermann_O's avatar
Hermann_O
Level 3
7 years ago
Solved

Cancel MSSQL legacy batch job

Hello all,

I've got a question regarding mssql batch jobs.

I've configured a MSSQL policy to use batch files and configured a job to backup DATABASE $ALL.

When I know run this backup job it works fine but in case I want to cancel the job it doesn't behave like I expected.

I've started a manual backup job, the parent job starts and 4 child jobs (50 databases are running on that instance; 4 parallel backups are allowed). Now I cancel the parent job but the child jobs keep on going - even after 4 backups are completed the next 4 child jobs appear and run. So the backup finishes completely but I wanted the job to stop before.

Do you have any ideas how I can cancel the job so no more backups are done?

Thanks in advance.

  • Hermann_O 

    Cancelling from NBU won't help, beause the child jobs are being initiated from the script that is running on the client.

    You need to locate the backup processes on the client in Task Manager and cancel that. 

2 Replies

  • Hermann_O 

    Cancelling from NBU won't help, beause the child jobs are being initiated from the script that is running on the client.

    You need to locate the backup processes on the client in Task Manager and cancel that.