Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brandonl
Yak Posting Veteran
58 Posts |
 Posted - 2005-02-02 : 10:31:40
|
| I have several DTS packages on a server that I only have access to a couple databases through my login. They were scheduled by a different user, and I (of course) can't see the jobs to view the job history to debug a problem with the jobs.Are there special permissions I can be assigned to see the other scheduled jobs, or will I need to be elevated to System Administrator to see them?~BrandonL |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-02 : 10:53:54
|
| I think that's the deal, yes.However, maybe a sysadmin could temprarily reassign the ownership of the jobs to your login with:sp_manage_jobs_by_loginrockmoose |
 |
|
|
brandonl
Yak Posting Veteran
58 Posts |
Posted - 2005-02-02 : 15:43:29
|
| Yep. That's what it took. Elevating my account to SA, long enough for me to transfer ownership of the jobs to my account. Eesh...~BrandonL |
|
|
|
|
|
|
Permissions to see scheduled jobs