Re: TSQL to find all running SQL Agent jobs

From: avnrao (avn_at_newsgroups.com)
Date: 12/01/04 

Date: Wed, 1 Dec 2004 13:04:24 +0530

sp_help_job @execution_status = 1 will return all jobs that are currently
executing.

you can refer to system tables like sysjobs* for making the query. but its
not recommended. always use sp_* procedures.

Av.
http://dotnetjunkies.com/WebLog/avnrao
http://www28.brinkster.com/avdotnet

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:#dcFFV31EHA.2016@TK2MSFTNGP15.phx.gbl...
> I've looked at sp_help_job but cant really seem to find out current
> execution status . So basically I want to be able to run a TSQL that will
> list all jobs that are currently running
>
>

Relevant Pages

  • Re: At job not executing
    ... >output of that command will go in the user's email. ... while crontab jobs are correctly executed on ... >possible that cron keeps subsequent at jobs in the queue if the limit ... not just not executing. ...
    (comp.unix.sco.misc)
  • Re: SQL agent jobs fail after upgrading windows2000 to windows2003
    ... It sounds like you are executing something other than T-SQL in your jobs. ... > Executed as user: SQLAdmin. ...
    (microsoft.public.sqlserver.server)
  • How to restart executing jobs after server reboot?
    ... the server maintenance people reboot the server? ... After the reboot, I ... have been manually restarting any jobs that were executing or retrying. ...
    (microsoft.public.sqlserver.dts)
  • Re: How to restart executing jobs after server reboot?
    ... Have a job that starts at agent startup. ... In your jobs you create add a step at the start that inserts into a table the time it started. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > have been manually restarting any jobs that were executing or retrying. ...
    (microsoft.public.sqlserver.dts)
  • Re: Putting a Cap on QZDASOINIT CPU % ?
    ... performance for the JDE users - particularly when the query is not ... couple of QZDASOINIT jobs to grab 25% CPU each. ... such a cpu consumption per job for an sql query; ...
    (comp.sys.ibm.as400.misc)