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!!!

Try this
1. have the sysadmin create the schedule job (then disable it)
2. have the sysadmin create a stored procedure to call the job
3. have the sysadmin grant you execute to the stored procedure
4. then you create a job from the store procedure and schedule it.



Jaime E. Maccou