sql server msde: Hi,

I have just installed SQL Server 2005 Express Adv. which I expected to
have the Agent service.
How do I install the agent service and where can I get it from??

Thanks

Hi,

SQL Server 2005 Express Edition doesn't have SQL Agent.
Only in Workgroup, Standard, Developer and Enterprise Editions.

TC

[quoted text, click to view]

hi,
[quoted text, click to view]

SQLExpress does not feature the SQL Server Agent, so jobs and alerts are not
available as well.. for scheduled "actions" you have to rely on the native
OS scheduler or third party schedulers..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply