Results 1 to 2 of 2

Thread: Running Task stays active

  1. #1
    Karen Seymour Guest

    Running Task stays active


    In a SQL Server 6.5 database a task appears in the Running Tasks tab as Active. I have tried to Stop it for 2 hours but it will not disappear. When I run dbcc opentran against the database it says there are no Active open transactions. I also can't see anything in Current Acitivity.

    The task is a scheduled task that runs daily and it has run OK both before and after this Active task

    Does anyone know how I can get rid of it

  2. #2
    David Lee Guest

    Running Task stays active (reply)

    One definite way to get rid it is to stop and start sql server.


    ------------
    Karen Seymour at 7/27/01 10:15:42 AM


    In a SQL Server 6.5 database a task appears in the Running Tasks tab as Active. I have tried to Stop it for 2 hours but it will not disappear. When I run dbcc opentran against the database it says there are no Active open transactions. I also can't see anything in Current Acitivity.

    The task is a scheduled task that runs daily and it has run OK both before and after this Active task

    Does anyone know how I can get rid of it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •