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
Jihad 0 Light Poster
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
You have to have full version of SQL Server not just Express...
Jihad 0 Light Poster
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 2,532 Code tags enforcer Team Colleague Featured Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.