 |  |  |  |  |  |  |  |
problem with sql server agent
Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
thanks
•
•
Join Date: Dec 2004
Posts: 4,122
Reputation: 
Solved Threads: 472
You have to have full version of SQL Server not just Express...
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
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.
•
•
Join Date: Dec 2004
Posts: 4,122
Reputation:
Solved Threads: 472
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
To understand what I'm saying here is link of SQL server Comparison, check out Manageability table last row
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
|
Similar Threads
- Cannot find server or DNS Error - please help! (Viruses, Spyware and other Nasties)
- SQL 2000 ODBC and SP4 problem (MS SQL)
- IE7 Redirecting to inactive sites - Major problem - HELP ! (Viruses, Spyware and other Nasties)
- explorer.exe problem - Keeps restarting (Viruses, Spyware and other Nasties)
- Need urgent help. Problem with SQL and win server. (Windows NT / 2000 / XP)
- Hijack this log. Random hyperlink problem (Viruses, Spyware and other Nasties)
- Help ! Cann't shut down window (Viruses, Spyware and other Nasties)
- windows explorer won't open. (Viruses, Spyware and other Nasties)
- Cannot find server or DNS Error Explorer & usps.com (Windows NT / 2000 / XP)
- startup problem (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)
- Next Thread: Problem using JOIN with six tables
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS SQL Posts
- Today's Posts
- Unanswered Threads