Scheduled jobs and Current Activity in SQL Server 7.0

I had scheduled data transfer and backup jobs that could not complete
executing as there was not enough disk space. On stopping the jobs the
process associated with it did not clear out from the Current Activity
Process Info window. I tried stopping and starting the SQL Agent and also
killing the processes but the processed associated with those jobs still show
up in the Current Activity - Process Info window of Enterprise Manager.
I have created disk space on the drives that were running out of space.
What should I do to kill those processes.
KT
Two thoughts here:
First did you refresh your current activity view? Second is there some
process are there any blocking processes. Sometimes a process might be
running that is blocking the processes you are trying to kill. In this case
those killed processes will not die, until the process that is causing the
block is no longer blocking.
----
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"KT" <KT@.discussions.microsoft.com> wrote in message
news:4EDD5693-2DAC-4CC9-B9E6-DE745EF630BF@.microsoft.com...
> I had scheduled data transfer and backup jobs that could not complete
> executing as there was not enough disk space. On stopping the jobs the
> process associated with it did not clear out from the Current Activity
> Process Info window. I tried stopping and starting the SQL Agent and also
> killing the processes but the processed associated with those jobs still
show
> up in the Current Activity - Process Info window of Enterprise Manager.
> I have created disk space on the drives that were running out of space.
> What should I do to kill those processes.
> --
> KT