question

DaveGray-0128 avatar image
0 Votes"
DaveGray-0128 asked BertZhoumsft-7490 commented

Timeline for SQL agent jobs

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.

sql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,@DaveGray-0128

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Bert Zhou

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BertZhoumsft-7490 avatar image
0 Votes"
BertZhoumsft-7490 answered

Hi,@DaveGray-0128

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.