Schedule DAC service to run without making it a Windows Service

The DAC service is dependent on the database connections which can sometimes be unpredictable because of network fluctuations. DAC services can also fail to start if the server has to be rebooted or the database crashes due to load on the database.

Since DAC is not a 'Windows' service, we noticed it frequently crashed, sending emails like :
'DAC Server shutting down' which were not very helpful.

After which scheduled loads would not run as the 'server' was down.
To mitigate this, we moved DAC to 'scheduled tasks '. This way we set it up to restart everyday at 4:00 AM before the load was scheduled to run. You can add other schedules as well to ensure that it restarts on every reboot or twice a day.

Since then we have never had a problem of missed loads or the server being down at odd hours of the day.

Thanks for reading.
Anisha