scheduling maintenance activities


  • Am I able to do this in SS Express  -like a backup or something or do I need to purhcase a SQL Server Agent (I believe I saw a 3rd party company always advertising this in SQL Server It's cheap -- just curious if I really need it.
    Monday, June 26, 2006 1:27 PM


  • SQL Express does not contain any specific scheduling tools. You can schedule T-SQL scripts to be run using Windows Task Scheduler and SQLCmd, which is a free solution as Task Scheduler is part of Windows.

    For more complex needs, a third party scheduling tool is an option.


    Mike Wachal
    SQL Express team

    Mark the best posts as Answers!

    Monday, June 26, 2006 10:41 PM