Management Studio Express - SQL Agent?

[yetanotherjo]

Silly question - I'm probably just blind, but...
Where do I get access to the SQL Server Agent to set up maintenance jobs, in Management Studio Express? (It's pointed at SQL Server 2000 at the moment if that makes a difference.)

 

[mrdenny]

I'm not sure if the Express Managment Studio can configure SQL Agent. SQL 2005 Express doesn't have the SQL Agent so the client may not be able to configure an agent.

Assuming it looks like the standard SQL 2005 GUI it'll be under Management in the list (not in it, but under it).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com

 

[yetanotherjo]

Bummer! Looks like it's not available. Is it possible to set up a stored procedure (or something) to automatically run shrink/reindex/backup etc on a schedule then?

 

[mrdenny]

You can easily write a procedure to do these things, however you'll need to have some scheduler out side of SQL Server run SQLCMD and have that call the proc.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com

 

[yetanotherjo]

Ok. The procedure I can do. Do you have any recommendations with regards a scheduler? Their IT guy is on break at the moment so I'm not sure if they have anything already but best to be prepared.

(Thanks for the replies by the way, Denny. You're a very helpful person!)

 

[mrdenny]

no problem. Windows Task Scheduler will probably do the trick for you.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com