Not absolutely sure if this is the same issue, but from the initial post, we have had the same issue (on a standalone SQL2000 RTM install). A job exists with...

Paul's CASE use to build the dynamic SQL string is correct; but he's also right that people will be against Dynamic SQL! It's less efficient, generally, because of the execution...

The begin...end is useful; it adds readability and I've had problems with comments in an IF with no BEGIN...END.

To speed things up, if the SPs to execute are mutually exclusive...