Scheduled agent jobs in SQL Server Express ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » Scheduled agent jobs in SQL Server Express ?

Scheduled agent jobs in SQL Server Express ?

Rate Topic

Display Mode

Topic Options

Author

Message

onlo

Posted Thursday, October 16, 2008 2:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 19, 2012 4:11 AM
Points: 187, Visits: 515

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

krayknot

Posted Thursday, October 16, 2008 2:58 AM

Old 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 »

Permissions