Query to return job history

[aolb]

I would like to write a query returning job history data.

does anyone know where this data is held? I have just had a quick look at the master system tables and there is nothing obvious. Maybe there is an stored procedure?

 

[vongrunt]

Database msdb, table sysjobhistory.

Sproc: sp_help_jobhistory

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[aolb]

thanks, i was looking in the wrong db.