SQL Server Agent in Express Edition
As you probably know, SQL Server Express doesn’t ship with SQL Server Agent.
This is a known limitation and many people offered alternative solutions to schedule jobs, including windows scheduler, free and commercial third-party applications.
My favourite SQL Server Agent replacement to date is Denny Cherry’s Standalone SQL Agent, for two reasons:
It uses msdb tables to read job information. This means that jobs, schedules and the like can be scripted using the same script you would use in the other editions.
[Read More]