Is there a table that I can access through a query that will allow me to
look up the job log history of jobs run by the SQL Server Agent? I have a
DTS package that runs nightly (via a job) and would like to create a query
to pull success/fail information from the job history.

Thanks,

Chet

Found the answer to my own question:

EXEC sp_help_jobhistory NULL, 'Job Name'

If this is stored in a table I'd still like any info on how to access it
using a SELECT statement.

Thanks.

"Chet Cromer" <chetsjunkATccrtc.com> wrote

Easiest way to find out is to do

Use MSDB
Go
Exec sp_helptext 'sp_help_jobhistory'


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Chet Cromer" <chetsjunkATccrtc.com> wrote