I need to build out a dependency tree for SQL jobs. I need a query to run against all of the servers in the farm to list out each job with the source/destination server(s), affected database(s), schedule, basically everything about the job. There are thousands of jobs so doing this manually isn't realistic.
[url]https://www.google.com/search?q=SQL+2008+Query+to+list+all+jobs&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[/url]
Here is a hint: no one in this sub forum will know anything about shitty microsoft sql
[highlight](User was banned for this post ("Threadshitting" - UberMensch))[/highlight]
On whatever machine you have SSMS on, you'll probably need to set up a linked server for all your servers for ease of use. That should make it easy to run the above query on all of your servers, not a real easy way to automate everything without writing some sort of C# or Linq script.
[QUOTE=Protocol7;33242016]On whatever machine you have SSMS on, you'll probably need to set up a linked server for all your servers for ease of use. That should make it easy to run the above query on all of your servers, not a real easy way to automate everything without writing some sort of C# or Linq script.[/QUOTE]So there aren't any SP's to do this? I'm sure one can be written...
[QUOTE=jordguitar;33240605][url]https://www.google.com/search?q=SQL+2008+Query+to+list+all+jobs&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[/url]
Here is a hint: no one in this sub forum will know anything about shitty microsoft sql[/QUOTE]Shitty MSSQL huh? So MySQL is so much better? I'm glad I'm not taking advice from you.
[QUOTE=jordguitar;33240605][url]https://www.google.com/search?q=SQL+2008+Query+to+list+all+jobs&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[/url]
Here is a hint: no one in this sub forum will know anything about shitty microsoft sql[/QUOTE]
Here is a hint: keeping your opinions to yourself will prevent you from getting banned next time.
Also in corporate IT, Microsft SQL is used everywhere.
[QUOTE=UberMensch;33246015]Here is a hint: keeping your opinions to yourself will prevent you from getting banned next time.
Also in corporate IT, Microsft SQL is used everywhere.[/QUOTE]Yep, commercial support is better than some 12 year olds in a public forum.
[QUOTE=faze;33245277]So there aren't any SP's to do this? I'm sure one can be written...
Shitty MSSQL huh? So MySQL is so much better? I'm glad I'm not taking advice from you.[/QUOTE]
You can probably throw what he posted into a stored proc on each server and then call them all from a single script.
[QUOTE=Protocol7;33252128]You can probably throw what he posted into a stored proc on each server and then call them all from a single script.[/QUOTE]I'll give it a try Monday. Thanks.
Sorry, you need to Log In to post a reply to this thread.