Monday, March 12, 2012

query to get list of scheduled jobs/duration

Does anyone have a query that will list all the jobs, their schedule and
duration?
Many thanks in advance!
Robin,
The attached stored procedure lists job history, status, etc. for a given
date.
-- Bill
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:972F67C8-62D5-4664-9006-28ED8C2E53CF@.microsoft.com...
> Does anyone have a query that will list all the jobs, their schedule and
> duration?
> Many thanks in advance!
|||Thank you for your reply!
I did not get the SP though - would yuo please repost it?
many, many thanks!
"AlterEgo" wrote:

> Robin,
> The attached stored procedure lists job history, status, etc. for a given
> date.
> -- Bill
>
> "RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
> news:972F67C8-62D5-4664-9006-28ED8C2E53CF@.microsoft.com...
>
>

No comments:

Post a Comment