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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-29 : 08:22:06
|
| Michele writes "I have a DTS package that executes fine. When I try to schedule it (right-click package and click schedule) it fails b/c non sys admins don't have rights to run CmdExec job steps.When my system administer schedules the DTS package it also runs fine. I would like to be able to schedule it to run during off-peak hours, without requiring an active connection from my machine. I prefer not to ask the sys admin every time I need to have the DTS executed.Is there any way for a non-system administer to schedule a DTS package?VERSION INFO: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) " |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-29 : 12:12:43
|
| Michele,Just schedule it so that it creates the job. Then any time that you want to modify the schedule, you can just run sp_update_jobschedule. You just need to be a member of the public role in the msdb database to be able to do this. sp_update_jobschedule is documented in SQL Server Books Online. Have a look at sp_start_job as well.Tara |
 |
|
|
|
|
|
Can a non-system administrator schedule a DTS package?