Ok Gerald I will try. Basically I am not a TSQL expert or from programming back ground.

Hi Gerald,

1 last question,

1. Suppose if I want to list out the jobs which has to run on a <<specific date>>, how to pull that info using tsql...

Thats Awesome. Thank you Gerald. This helps 🙂

Thanks Jeff for the pointers. Will go through them.

Hi,

Its just an example. I want a query to pull jobs which are taking more than normal/deviating from baselines.

Thanks a ton for the help.

Thank you. Again, just checking if there is a script which can script out all the Linked servers for a SQL instance at 1 go?

Thanks Josh. Agree with what you said.

Thanks Perry. will check.

Thank you all.

Gail, you are absolutely spot on. But what kind of information do I need to share with the AD admins?

I mean what kind of conversation do I need to have...

Couple of follow up questions.

Question 1)

I see below messages for each database which are part of AG.

What does below messages indicate?

db1 "SECONDARY" to "RESOLVING"

db1 "RESOLVING" to...

Thank you for the help.

Leo,

Thank you for your input. Could you please share the create script for any test job which has includes above functionality so that I can repro at my end?

-Sam

That's a good option to consider as well. Thank you sir for the continuous help.