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 |
|
Crowandazi
Starting Member
9 Posts |
 Posted - 2005-03-09 : 10:55:44
|
| Can only members of sysadmin schedule DTS jobs? Greetings all,This is an offshoot question from one of my earlier posts. I can't get any of my DTS jobs to run if I schedule them. A number of posts have suggested that I get sysadmin rights in order for my logon to have the ability to run "xp_cmdshell".However, I can't get these rights because it is not my server. Can only members of sysadmin schedule DTS jobs? Does this mean I'm out of luck?I can't believe I'm the only person in the world who has had to schedule a job on a server he didn't own. Can someone PLEASE clue me in as to what needs to be done to allow my logon to schedule jobs? I'm desperate!!! |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-09 : 11:26:57
|
| Can whoever created the job change the owner of the job to your login?Be One with the OptimizerTG |
 |
|
|
|
|
|
Can only members of sysadmin schedule DTS jobs?