[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

change job owner for all jobs

is there a method to change the job owner for all the DTS packages on the server?

Thanks
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
tbsgadiCommented:
0
 
anushahannaAuthor Commented:
Gary, thanks - it is helpful to know how to change the owner of a DTS package; but rather, I need to be able to change the owner of a scheduled job.
0
 
anushahannaAuthor Commented:
Gary, the second link is also pointing to the same SP. (sp_reassign_dtspackageowner) we almost need something like sp_reassign_jobowner
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now