sql2005企业版有"SQL Server 代理"这个功能吗?

[zhiweixuexi8]

sql2005企业版有"SQL Server 代理"这个功能吗? 我装了怎么没有?应该怎么弄才有了?

[htl258_Tony]

有肯定是有的，估计是你安装的时候没有选上相关模块。

[百年树人]

这个跟开发版应该是一样的
服务名称叫“SQL Server Agent (MSSQLSERVER)”
进程名称叫：SQLAGENT90.EXE

[--小F--]

你不会是在XP上装SQL 2005 企业版吧

[--小F--]

不然就是没装上

[rucypli]

chongzhuang.....

[zhiweixuexi8]

SQL Server Agent 在哪装~~是在装sql2005的时候一起装吗? 我打开外围配置 里面显示的是正在运气 但是打开后只有如图:

[zhiweixuexi8]

[zhiweixuexi8]

我想用代理作业进行定时备粉始终弄不出来建维护向导的

[曾与未来梦]

[Quote=引用 2 楼 josy 的回复:]
这个跟开发版应该是一样的
服务名称叫“SQL Server Agent (MSSQLSERVER)”
进程名称叫：SQLAGENT90.EXE
[/Quote]

服务名称叫“SQL Server Agent (MSSQLSERVER)”
管理工具>服务 里的这个是启动了的

进程名称叫：SQLAGENT90.EXE
也有这个进程~~

但是打开SQL Server Management Studio Express后目录树里就是没有~~~~还有哪没弄对?

[zhiweixuexi8]

应该用什么?

[csw200201]

[Quote=引用 13 楼 zhiweixuexi8 的回复:]
应该用什么?
[/Quote]

You should be using SQL Server Management Studio that comes with SQL Server Enterprise Edition. Make sure you have installed the SQL Server Management Studio when you install SQL Server Enterprise Edition (and remove SQL Server Management Studio Express edition).

[zhiweixuexi8]

SQL Server Management Studio 非Express版 在哪下载哦?

[csw200201]

[Quote=引用 9 楼 zhiweixuexi7 的回复:]
服务名称叫“SQL Server Agent (MSSQLSERVER)”
管理工具>服务 里的这个是启动了的

进程名称叫：SQLAGENT90.EXE
也有这个进程~~

但是打开SQL Server Management Studio Express后目录树里就是没有~~~~还有哪没弄对?
[/Quote]

SQL Server 2K5 Express Management Studio does not let you manage SQL Server Agent. However, if you are familiar with Transact-SQL, it is always possible to manually configure an agent job via Transact-SQL. Alternative includes using creating a batch script and using Windows Scheduler to execute the script using SQLCmd.exe utility.

[csw200201]

[Quote=引用 15 楼 zhiweixuexi8 的回复:]
SQL Server Management Studio 非Express版 在哪下载哦?
[/Quote]

Are you using SQL Server Enterprise edition or express edition? If you are already running the Enteprise Edition, you should have the Management Studio as part of the installation media.

Otherwise, there isn't a place to just download Management Studio for the Enterprise Edition. However, one trick to get around it is to download the trial version of SQL2K5 Enterprise edition from MS website and only install the Management Studio portion of the product (http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

[cailee]

sql server agent

[csw200201]

If you are running SQL Server 2005 Enterprise Edition, you shouldn't be using SQL Server Management Studio Express to manage it. The expression edition of the management studio does not have the ability to manage SQL Server Agent.