You might want to look at msdb.dbo.sp_get_composite_job_info instead, single row per job, gives you running status.

Thanks for the mention on DbFriend!

I'm going to be moving this project over to Google Code since the subversion support is native, and ultimately, DbFriend should become a database-agnostic tool.

The...

I use DbFriend for:

- clean organization (I can put my files anywhere on disk, not just where SMSS says).

- clean, repeatable scripts (SMSS script options are many and if I...

For scripting all your SQL objects to a Visual Studio Database project, you should do a Google search for "DbFriend".

For scripting all your SQL objects to a Visual Studio Database project, you should do a Google search for "DbFriend".

For scripting all your SQL objects to a Visual Studio Database project, you should do a Google search for "DbFriend".