Scheduling jobs

• harriet.louis

  Ten Centuries

  Points: 1225

  More actions

  February 17, 2009 at 6:58 am

  #218567

  SQL Server Agent is missing from SQL Server Express, and I have a couple of jobs that needs to be migrated to Express. Does anyone know of a work around to get the same affect?;)

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 17, 2009 at 7:44 am

  #945200

  You can use windows scheduler to run batch files using sqlcmd. You can also take a look at this:

  http://weblogs.asp.net/alex_papadimoulis/archive/2005/11/10/Express-Agent-for-SQL-Server-Express_3A00_-Jobs_2C00_-Jobs_2C00_-Jobs_2C00_-and-Mail.aspx

  I believe that Denny Cherry is also working on an Agent for SQL Server Express, but I couldn't find a reference to it.

  Check out the results from this as well:

  http://lmgtfy.com/?q=SQL+Server+Agent+for+SQL+Express

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  February 27, 2009 at 6:55 am

  #951134

  I can't get sqlcmd to run my backup script through scheduled tasks. How would you setup the run line to call the sqlcmd and script?

  Thanks.