Solved

change job owner for all jobs

Posted on 2010-08-17
4
397 Views
Last Modified: 2012-05-10
is there a method to change the job owner for all the DTS packages on the server?

Thanks
0
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 33461793
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33466443
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
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 500 total points
ID: 33472272
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33477472
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question