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.
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.