November 26, 2010 at 6:09 am
Hi ,
I have noticed that some time in the past few weeks an update was made by my sql service account, I thought I would check my jobs but there are 70 + jobs set up. There seems to be hardly any information showing not like in sql 2000?
How can show next and last run times of all the jobs at once?
How can I find out what jobs ran during a particular time?
Many thanks
November 26, 2010 at 6:24 am
For the first one, look in Job Activity Monitor. For the second, you'll need to write a query against sysjobhistory (like I think you would also in SQL Server 2000). You can either write it yourself, or search the internet to see whether anyone's done it already.
John
November 26, 2010 at 7:07 am
John Mitchell-245523 (11/26/2010)
For the first one, look in Job Activity Monitor.
Job Activity Monitor is not available in SQL Server 2000.
Like John mentioned for the second you need to get that information using a query. Like the one here[/url] on SSC
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply