While I don’t understand what you mean when you say “Path Execution Job” or “execution type deployment,” I do understand what you wrote about your SQL and IIS servers. If you want to have one server be updated, rebooted, and then come back online before the second server begins updating, you can accomplish this with either the ‘Basic Multi-Row Queue Sequence’ or the ‘Advanced Multi-Row Queue Sequence.’
Here are a tutorials explaining how to use them:
Basic Multi-Row Queue Sequence Tutorial 1
Advanced Multi-Row Queue Sequence Tutorial 1
Advanced Multi-Row Queue Sequence Tutorial 2
-Doug