sql server msde: It appears that SQL 2005 Express has removed the SQL Agent. Is this true?
Or, am I simply missing something obvious? If not there, does anyone know
the minimum version of SQL 2005 which enables job scheduling?

Thank in advance,
Gary Johnson

Hello,

Yes it is. SQL Express do not have SQL Agent. You could use Windows
schedular to schedule the tasks like Backup, Monitoring, Procedure execution
ect...

See the info from Microsoft URL:-

SQL Agent

SQL Agent is a SQL Server service that is used to automatically schedule job
execution for SQL Server. It is typically used to schedule the execution of
DTS packages or to perform system maintenance tasks like database backups.
While MSDE includes the SQL Agent service, SQL Server 2005 Express does not.
However, you can use the Windows built-in Task Scheduler to schedule jobs
for SQL Server 2005 Express. You can use Task Scheduler in combination with
the downloadable DTS runtime to automatically schedule the execution of DTS
packages. Likewise, you can use Task Scheduler in combination with the SQL
Server 2005 Express command-line SQLCMD tool to regularly execute SQL Server
2005 Express system maintenance jobs like database backups and other
database access jobs.

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx



Thanks

Hari




[quoted text, click to view]

Service Broker also works well as a job scheduler and is available in SQL
Express:

http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx
http://www.microsoft.com/technet/technetmag/issues/2005/05/ServiceBroker/default.aspx

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]