In my case (not being an administrator, or maybe it's just our new SQL 2005 database) the master.sys.columns only has 44 rows, and the query only supplies 85,184 rows (44...

Thanks for the article - I can see that this is useful.

We are only now starting to use SSIS and monitoring job status would be useful to me for my...

The second function uses the guid to fetch last_executed_step_id

The function is only returning the ID of the last step executed, not the status of the job.