'Is it possible to run a job with multiple stores running in it at the same time in SQL server?

enter image description here

I want to run 1 store multiple times like this in jobs. But somehow there is a problem that jobs only runs the first line of insert and the following lines do not run. If I run it separately outside of new query it still runs the lines normally.

exec [WF_Jobs_Insert] @tbl, 0, 200
go
exec [WF_Jobs_Insert] @tbl, 201, 400
go
exec [WF_Jobs_Insert] @tbl, 401, 600
go
exec [WF_Jobs_Insert] @tbl, 601, 800
go
exec [WF_Jobs_Insert] @tbl, 801, 1000
go
exec [WF_Jobs_Insert] @tbl, 1001, 1200
go
sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions