none
Sheduled SQL restart does not work RRS feed

  • Question

  • Hello,

     Windows 10 Pro. Because of periodic slowdowns of SQL server, I decided to create a daily event for restarting SQL server instance service as a workaround. So I created nightly stop-start shedule events for the instance:

     NET Stop "mssql$myinstance" - sheduled on 11:30PM

     NET Start "mssql$myinstance" - sheduled on 11:32PM

    Both running with highest priviledges, password provided during setting up the event.

    I created them at the end of April 2019 and it worked for maybe few days (under "Application" node there were MSSQL start/stop  events logged), probably until some system update. Since then, I've been unable to make the sheduled events work, deleted them and created again, tried many solutions, no luck. There is a successful login event but seems like no further action is taken, the sql server is not restarting automaticaly anymore. Also, there are 1534 events on  11:30PM/11:32PM which I apparently should not care about.

    Any reason for such behaviour? How can I trace the problem to find out what exactly happens when system is trying to execute NET command?

    Thank you

    Best regards

    Krzysiek

    Wednesday, May 22, 2019 12:01 PM