Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
ArjanFraaij
Frequent Visitor

Change user that runs the scheduled pipeline (SPN)

Hi All,

When you create a schedule this is using the current user context for the schedule. So when user X did create the schedule and this user is not longer member of our organization and his user account is inactive the schedule won't run anymore.
Giving a message like:

ArjanFraaij_0-1736331283126.png


How ever it's not possible to set a specific user for a schedule or change it after, or I can not find it 🙂

So do any of you know or it is posible to set a SPN as the executer of a schedule?

Regards,

Arjan

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

Based on my understanding, as of today this is a limitaion wherein you cannot change the ownership directly.

You can either edit the trigger and save for it to work out or create a new trigger and delete the old one.

Also SPN support is yet not availabe at data pipeline or its API but the above idea is in backlog for next couple of months




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

1 REPLY 1
NandanHegde
Super User
Super User

Based on my understanding, as of today this is a limitaion wherein you cannot change the ownership directly.

You can either edit the trigger and save for it to work out or create a new trigger and delete the old one.

Also SPN support is yet not availabe at data pipeline or its API but the above idea is in backlog for next couple of months




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Helpful resources

Announcements