scheduled jobs in 2005 Express?

[yetanotherjo]

Ok, I've found the TSQL stuff which sets up jobs and assigns them to schedules which seems to set up ok in Express, except the schedule doesn't fire. Is this because Express doesn't include Agent and having the whole job/schedule thing in there is just another MS tease?

 

[mrdenny]

Correct, SQL Express doesn't include SQL Agent.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[yetanotherjo]

Ah well, back to my faithful old .cmd files then.....thanks Denny.

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com