Home Forums SQL Server 2008 SQL Server 2008 Administration Sql Server - Running a Job on Multiple servers RE: Sql Server - Running a Job on Multiple servers

  • January 30, 2015 at 6:38 pm

    #1774521

    SmilingLily (1/30/2015)

    I am using SqlServer 2008.

    I have a Sql Server Job that checks Disk Space and emails admins if the space is less than 15%

    Instead of adding that Job to all servers is it Possible to run the Job on all servers ?

    (I have those servers added as Linked Servers)

    If you have the Enterprise Edition you can set up a Master server to hold a set of jobs that are then deployed to Target servers. The management of the job is centralized on the Master server, giving you one point of management.

    If you don't have Enterprise Edition then there is one thing that comes to mind. You could query sys.servers for returning the Linked Server names. Then dynamically build a SQL statement to execute your disk space check using the Linked Server names to traverse your network to check disk space on the other servers.