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 Central.com). It's cheap -- just curious if I really need it.

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.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

sql