Is there a way to auto resume an incomplete job after sql server restart?
In a nutshell maybe. If you have a sql job without a notion of persistence then no:( The job will continue to run according to schedule but it will not pick up from an earlier starting point unless you have to logic to do so.