Click here to Skip to main content
14,980,646 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
my system, there is sql server management studio express 2005 i want add SQL server agent feature in it for creating Job. but without any harm to my All Databases, how can i do it ?
Updated 10-Apr-15 9:15am
Mehdi Gholam 9-Apr-15 4:48am
Just run the setup, databases are not effected.
Maciej Los 9-Apr-15 14:12pm
What's the issue?

I believe you already asked this question. Just go through the setup process and select to add features to an existing install.
SQL Server Express does not include SQL Agent:
Features Supported by the Editions of SQL Server : Management Tools[^]

You will need to use a third-party solution to manage and execute scheduled jobs in SQL Express. For example:
SQL Agent: A Job Scheduler Framework[^]
Standalone SQL Agent[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900