Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scheduled agent jobs in SQL Server Express ? Expand / Collapse
Author
Message
Posted Thursday, October 16, 2008 2:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:42 AM
Points: 193, Visits: 541
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 ?
Post #586794
Posted Thursday, October 16, 2008 2:58 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 07, 2011 1:41 AM
Points: 346, Visits: 534
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
Post #586799
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse