how can I list running jobs

Hi,
I am experiencing db high cpu, no apps can run, how can I list running jobs?
ThanksJen wrote:
> Hi,
> I am experiencing db high cpu, no apps can run, how can I list
> running jobs?
> Thanks
Exec msdb..sp_help_job @.execution_status = 1 -- just edxecuting
or
Exec msdb..sp_help_job @.execution_status = 0 -- not idle or suspended
David Gugick
Imceda Software
www.imceda.com|||On Fri, 21 Jan 2005 10:07:04 -0800, Jen
<Jen@.discussions.microsoft.com> wrote:
>Hi,
>I am experiencing db high cpu, no apps can run, how can I list running jobs?
exec sp_who2
Shows CPU, blocks.
Or use the Enteprise Manager, Management / Current Activity /
Processes.
BTW, those are not referred to as "jobs", but as "threads", or
"processes", or "spids".
J.

how can I list running jobs

Hi,
I am experiencing db high cpu, no apps can run, how can I list running jobs?
Thanks
Jen wrote:
> Hi,
> I am experiencing db high cpu, no apps can run, how can I list
> running jobs?
> Thanks
Exec msdb..sp_help_job @.execution_status = 1 -- just edxecuting
or
Exec msdb..sp_help_job @.execution_status = 0 -- not idle or suspended
David Gugick
Imceda Software
www.imceda.com
|||On Fri, 21 Jan 2005 10:07:04 -0800, Jen
<Jen@.discussions.microsoft.com> wrote:

>Hi,
>I am experiencing db high cpu, no apps can run, how can I list running jobs?
exec sp_who2
Shows CPU, blocks.
Or use the Enteprise Manager, Management / Current Activity /
Processes.
BTW, those are not referred to as "jobs", but as "threads", or
"processes", or "spids".
J.

how can I list running jobs

Hi,
I am experiencing db high cpu, no apps can run, how can I list running jobs
?
ThanksJen wrote:
> Hi,
> I am experiencing db high cpu, no apps can run, how can I list
> running jobs?
> Thanks
Exec msdb..sp_help_job @.execution_status = 1 -- just edxecuting
or
Exec msdb..sp_help_job @.execution_status = 0 -- not idle or suspended
David Gugick
Imceda Software
www.imceda.com|||On Fri, 21 Jan 2005 10:07:04 -0800, Jen
<Jen@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi,
>I am experiencing db high cpu, no apps can run, how can I list running jobs?[/vbco
l]
exec sp_who2
Shows CPU, blocks.
Or use the Enteprise Manager, Management / Current Activity /
Processes.
BTW, those are not referred to as "jobs", but as "threads", or
"processes", or "spids".
J.