Scheduled agent jobs in SQL Server Express ?

• onlo

  SSCertifiable

  Points: 5080

  More actions

  October 16, 2008 at 2:48 am

  #214127

  I want to setup scheduled Backup agent job in a SQL Server Express machine just as the other agent jobs in SQL 2005 Standard or Enterprise Edition.

  But I found there is no agent job monitor in SQL Express.

  Is it possible to set up an agent on SQL Express ?

• krayknot

  SSCertifiable

  Points: 7998

  More actions

  October 16, 2008 at 2:58 am

  #885691

  There is no Agent job monitor in SQL Express.

  Here are some ways that can work as an alternatives::

  1. Create ur own service(especially window service), that will take care of the scheduled backup by calling the backup sp.

  2. use the following link if you can buy the 3rd party Agent utility: http://www.valesoftware.com/products-express-agent.php

  3. Create your own agent by following this link:

  http://www.codeproject.com/KB/database/SQLAgent.aspx

  The better you can do is the point 1. and 3.

  kshitij kumar
  kshitij@krayknot.com
  www.krayknot.com