That is a resourceful post. As you stated, there is no one single approach to tuning a proc. It is purely a case by case issue, so a variety of...

Using exec msdb..sp_help_job will return an output with a column indicating the current execution status, last run outcome etc etc, which needs to be interprated to know the meaning.

On...

If we talk about efficiency, we talk about using best practices. Abandoning the use of practice for an alternative method is tantamount to adding extra load.

With this said, I believe...