Post reply

how to find all sql agent jobs on all servers on domain

  • September 21, 2016 at 8:43 am

    #317724

    looking to do this by a sql script

  • September 21, 2016 at 11:53 am

    #1902257

    You can use:

    SELECT job_id, [name] FROM msdb.dbo.sysjobs;

    on each server.

  • September 21, 2016 at 11:58 am

    #1902259

    I'm trying not to click on every server. I am looking for a query where I can open ssms and run a query that will look at all servers on our DNS

  • September 21, 2016 at 1:25 pm

    #1902280

    In the Registered Servers window create a Central Managment Server and add all the required instances as New Server Registrations. Then you can right-click on the managing server, and choose New Query. This query will be executed on all the servers that are registered and the results "UNIONED" into one result set. The query posted above returns the Server Name, job_id, and name of each job on all my registered servers.

  • September 21, 2016 at 2:29 pm

    #1902292

    That worked. Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply