Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richardps
Starting Member
33 Posts |
 Posted - 2007-01-23 : 05:31:06
|
| In Enterprise Manager, (in Management| SQL Agent| Jobs) you are provided with a great view on the right pane showing many details of all the SQL Agent jobs on the server. This includes, whether it's enabled, scheduled, running, when it last run and when it will next run.Is there any way to obtain a similar overview of SQL Agent jobs in SQL Server 2005 Management Studio?Many thanks in advance,Richard. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-23 : 05:32:41
|
| If you look under sql agent there is the job activity monitor.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
richardps
Starting Member
33 Posts |
Posted - 2007-01-23 : 06:01:15
|
| Thank you!! (Thought I'd start with an easy one!) |
|
|
|
|
|
|
2005 Management Studio question