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 |
|
bluemetal
Starting Member
26 Posts |
 Posted - 2005-05-03 : 19:37:06
|
| Hi Guys, The topic says two things:1) When i schedule a DTS package for automatic execution, sometimes it works, sometimes it doesn't (the package's steps execute fine when executed manually). What can the problem be?2) Is there a way to manually setup the scheduler, what is the file DTSRun.exe for .. DTSExec?Any ideas and/or advices? Thanks! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-04 : 23:31:53
|
| 1) what's the error message? does it fail if you schedule it and runs fine if manually executed? - check if the job owner is allowed to execute the package and has permission to perform the tasks inside the package2)yes, it can be done manually, check DTSRun Utility in BOL--------------------keeping it simple... |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-05-05 : 00:00:28
|
| Jen,How do you find who is the job owner?Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
|
bluemetal
Starting Member
26 Posts |
Posted - 2005-05-05 : 03:35:09
|
| Hi,1) It just says "failed" when i check the logs window after execution time, yes it runs perfectly when executed manually and the uer has all the rights to the db, processes, bulk inserts, etc.2) Thanks, i'll look into that right away. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-05-09 : 04:30:29
|
quote:
Posted - 05/05/2005 : 00:00:28-------------------------------------------------------------------------------- Jen,How do you find who is the job owner?Karunakaran___________It's better to be loved and lost, than ever to be loved...
select s.name,u.name from msdb..sysjobs sjoin master..syslogins uon s.owner_sid=u.sid--------------------keeping it simple... |
|
|
|
|
|
|
|
|
DTS Scheduling Not Working / DTSRun.exe Question?