在作业中并行执行存储过程(SQL Server) [英] Parallel execution of stored procedures in job (SQL Server)

问题描述

首字母缩写: 我有五个存储过程，每个存储过程都没有依赖性.相同的是，它从五个不同的服务器中提取数据.我们只是整理并将其提供给我们的服务器.

Breif: I have five stored procedures and each of it have no dependencies. The identical stuff is that it pulling data from five different servers. We are just collating and feeding it to our server.

问题: 我们已将这五个任务安排在一个单独的工作中，并分5个步骤进行.我想并行执行而不是顺序执行.

Question: We have scheduled all these five in single job with 5 different steps. I want to execute it in parallel instead of sequential order.

额外: 实际上，我可以将所有五个存储的proc整理为一个，如果可以在sp级别并行运行它(如果在作业级别不可能).

Extra: I can actually collate all five stored procs in to one if its possible to run it in parallel in sp level (if not possible in job level).

谢谢

推荐答案

有几个选项.其中2个是:

There are several options. 2 of which are :

1. 创建SSIS作业以并行运行5个存储过程.
2. 创建5个同时安排的不同SQL Server代理作业

这篇关于在作业中并行执行存储过程(SQL Server)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！