THanks Jim..


------------
Jim at 8/23/01 11:13:07 AM

The only way I have been able to correct this is to stop and then restart the SQL Agent and then rerun the job.


------------
Anne at 8/23/01 10:16:04 AM


Hi,

On production server, I have two tasks in status "performing completion action" for last couple hours. Ususally these tasks take seconds to finish.
Do you know how can I kill or cancel these tasks? I tried to stop both the jobs couple times but nothing is happening.

There are no locks/blocks on current activity window.

Please give your suggestion.

Thanks.