How to schdule a shutdown, backup and startup of DB in NT - like cron - using the AT command. I tryed this but didn't work :
C:\ AT 20:30 /every:1,2,3,4,5,6 smart
where smart is the batch file that stops the DB, back it up and start it again. It says that the job is schduled but it never happen. I checked for the Schdule service in Control Panel-->Services, there is 'Task Schduler' service and it's started. What could be the problem.
you can use scheduled tasks under control panel. It has a scheduled task wizard. You just need to add your startup and shutdown scripts there. I think it's much simpler and less complicated than using @.