When deployed using SCCM 2012 R2 and the app deployment toolkit, is it possible to install Application A, restart then install Application B and restart all with one advertisement\deployment. The task at hand is to install a SQL service pack, a SQL CU and a security update for SQL all in one shot. SQL DBA would like the machine restarted at the beginning (before anything installs) then after each item installs.
You can do this but SCCM usually does not like having packages reboot by themselves.
SCCM sees self-rebooting packages as failed packages.
If you want to do this, the Execute-MSI function will skip over already installed MSIs by default.
IOW: You can do what you want but you will have to put all the logic for reboots and such in Deploy-Application.ps1 yourself. It’s not a feature at this time and probably won’t be for a while.
Good luck!