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.
Thanks in Advance...
Did the smart script work properly on the command prompt?
Life is a journey, not a destination!
shutdown, backup and startup in NT
Yah, the script is working properly form the command prompt.
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 @.
Click Here to Expand Forum to Full Width