Zack
asked on
How to Create a SQL Job that runs across multiple databases simultaneously - SQL Server 2008 R2
Hi EE,
How do I create a SQL Job that runs on multiple databases simultaneously - SQL Server 2008 R2 Below is the code I would like to run:
DELETE FROM [DATABASE_NAME].dbo.ScanRe cords
WHERE
Name = 'Empty Scan Record' AND Status = 1
Any assistance is welcome.
Thank you.
How do I create a SQL Job that runs on multiple databases simultaneously - SQL Server 2008 R2 Below is the code I would like to run:
DELETE FROM [DATABASE_NAME].dbo.ScanRe
WHERE
Name = 'Empty Scan Record' AND Status = 1
Any assistance is welcome.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers for the query suggestion, I just found a link that shows how to run a singular job to access multiple servers.
https://www.mssqltips.com/sqlservertip/1767/execute-sql-server-query-on-multiple-servers-at-the-same-time/
Thank you for your help.