Forum Discussion

Matthew_G's avatar
Matthew_G
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Data Pipeline executes multiple times

I have a pipleline and when it runs, either manually or scheduled, it executes multiple times. This seems to occur with any data pipeline we create. Is there something I am doing wrong?

 

To test I created a stored proc in a warehouse that inserts a date into a table. 

 

create table dbo.runCheck (
runDate DATETIME2(0)
)

create procedure dbo.p_insertDate
as
insert into dbo.runCheck(runDate)
select getdate()
GO
 
I then create a new data pipeline and add the stored proc activity.

 

 Confrim table is empty

 

Execute the pipline and check monitoring hub, I can see it is running multiple times 

 

 

Check the count again and I see there are multiple inserts

I'm not sure if I am doing something wrong or if there is a bug.