cancel
Showing results for 
Search instead for 
Did you mean: 

Cancel MSSQL legacy batch job

Hermann_O
Level 3

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

2 REPLIES 2

alicebolingeryn
Level 0

It's cool

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

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