Timeline for SQL agent jobs

Dave Gray 581 Reputation points
2022-05-17T10:26:56.003+00:00

Has anyone found a tool (other than Excel) that will build a horizontal timeline of SQL agent jobs?

Had a look at various project tools what produce a Gannt but they are not really working for this.

Thanks in advance.

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2022-05-17T14:32:03.37+00:00

    That is extremely difficult because Agent jobs can have multiple schedules. The best you can do is find the next runtime. It is very difficult to predict more than the next time.

    0 comments
  2. Bert Zhou-msft 3,421 Reputation points
    2022-05-18T01:29:53.57+00:00

    Hi,@Dave Gray

    Welcome to Microsoft T-SQL Q&A Forum!

    As far as I know you can use the dbatools.io tool to get what you want , click this link for more instructions.

    Best regards,
    Bert Zhou

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments