如何在我的SQL Server Management Studio Express 2005中添加SQL Server代理 [英] How to add sql server agent with my sql server management studio express 2005

问题描述

我的系统中有SQL Server Management Studio Express 2005 Installed.now，我想在其中添加SQL Server代理功能以创建Job.但对我的所有数据库没有任何危害，我该怎么办?

my system, there is sql server management studio express 2005 Installed.now 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 ?

推荐答案

我相信您已经问过这个问题.只需完成设置过程，然后选择向现有安装中添加功能.

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不包括SQL Agent:
SQL Server版本所支持的功能:管理工具 [ SQL代理:作业调度程序框架 [独立SQL代理 [ ^ ]
SQLScheduler [ ^ ]

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[^]
SQLScheduler[^]

这篇关于如何在我的SQL Server Management Studio Express 2005中添加SQL Server代理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！