Process runnable but wait indefinitely

There's a job that is scheduled to run indefinitely. The process's status is
"runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
= 3296, and it's not blocking any other processes or being bloked.
The waitresource is blank.
Please help!
DN
On Jul 26, 3:50 am, "DN" <tie...@.hotmail.com> wrote:
> There's a job that is scheduled to run indefinitely. The process's status is
> "runnable" but it does nothing. It has the lastwaittype = CMEMTHREAD, kpid
> = 3296, and it's not blocking any other processes or being bloked.
> The waitresource is blank.
> Please help!
> DN
Hi, what is the status on profiler? Do you see the counter increase
under the reads column?
|||Do you see the physical IO and CPU columns changing in sysprocesses
for that SPID, if so, then you might have to wait for it to complete.
Keep running sysprocesses to check if you see any changes in
lastwaittype.