Any particular reason to log it to a table, instead of just definining a view that queries the last hour of data?

Either way, you'll get most of your data out of msdb.dbo.sysjobhistory (details: http://msdn.microsoft.com/en-us/library/aa260416(v=SQL.80).aspx) and possibly out of the error log (there are ways to query this, but so far as I know they're all undocumented, so you'll need to research them yourself). Most of the data should be in the sysjobhistory table.