DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   problem with sql server agent (http://www.daniweb.com/forums/thread123539.html)

Jihad May 10th, 2008 11:02 am
problem with sql server agent
 
I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql server agent, I don't know if its there and I should enable it, or I should use another version of sql server or another version of sql managment studio. And is there a way to do it without using the sql server agent.
thanks

peter_budo May 10th, 2008 11:53 am
Re: problem with sql server agent
 
You have to have full version of SQL Server not just Express...

Jihad May 10th, 2008 12:22 pm
Re: problem with sql server agent
 
I tried to install a sql server developer edition. I don't know if it contains the sql server agent, but I didn't find it . I am using sql management studio express edition.

peter_budo May 11th, 2008 5:45 am
Re: problem with sql server agent
 
Managment studio is for managing things that are provided with server, so it will show agent option only if you get appropriate version of the software.
To understand what I'm saying here is link of SQL server Comparison, check out Manageability table last row


All times are GMT -4. The time now is 2:21 am.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC