Has anyone written a script or know of a script I could run to tell me what
SQL Agents jobs were running at a given point in time?

Thanks in advance,

Mark

Sullivan,

SELECT DISTINCT job.name
FROM msdb..sysjobhistory AS jh
JOIN msdb..sysjobs AS job
ON jh.job_id = job.job_id
AND jh.run_status = 4 -- In Progress

Look at the BOL for the sysjobhistory table to see the other values of
run_status.

Norman

get DTS Package Search at http://www.gerasus.com/

SullivanYee wrote:

Actually I am looking for jobs that ran in the past for example at '20060812
12:45'


"Norman Kelm" <norman (AT) no-spam (DOT) gerasus.com> wrote

You could still look at the same table but you will need to look at it a
litttle differently

run_date
int
Date the job or step started execution. For an In Progress history,
this is the date/time the history was written.

run_time
int
Time the job or step started.

run_duration
int
Elapsed time in the execution of the job or step in HHMMSS format.



These three columns should help you get the information you need

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"SullivanYee" <SullivanYee (AT) rcn (DOT) com> wrote