Unfortunately it is not recommended to run the macro from the publisher/server reload. The QlikView Server reference manual states: "QlikView Distribution Service Does not execute any macros that exist in the Source Document. "(chapter 27.1).
A workaround could be to perform the reload by a local client using a batch file that is launched by an external program of Task publisher.