Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 agent job feature in SQL server 2008 express

Author  Topic 

ConnieXujuan
Starting Member

48 Posts

Posted - 2012-02-22 : 16:58:09
Hi -,

I have installed SQL server 2008 Express and its SSMS on my laptop but there are no agent jobs feature.

I was just wondering what else I need to install to have the agent job feature?

Thanks a lot!!!

Connie

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-22 : 17:02:18
Express doesn't have that feature. You can schedule jobs using Windows Task Scheduler and call sqlcmd.exe to run T-SQL scripts.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ConnieXujuan
Starting Member

48 Posts

Posted - 2012-02-22 : 22:48:23
what if I install SQL server Management Tools?

Cheer,

Connie
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-02-22 : 23:29:36
Doesn't matter. It's the engine that doesn't come with it, not the tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -