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 |
|
trusted4u
Posting Yak Master
109 Posts |
 Posted - 2002-11-11 : 00:53:54
|
| Hi:I have created a DTS package which imports foxpro table in my db. It works fine when run manually. I want this package to run daily at 10.00am. so I tried scheduling it but it didn't work out. Then I tried creating a job which uses DTSRun utility and scheduled it, the job executes but the package doesn't gets executed. I am directly working on the Server using SA login and pwd. The cmd line in the Job is : Master.DBO.XP_cmdshell 'DTSRun /S MYSERVER /U SA /P SA /N DTSPACKAGE1'. Any help will REALLY be appreciated. ITS VERY URGENT.Thanks,Marjo. |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-12 : 12:57:33
|
| Strange problem... and I've stumpled upon it once already :DSQL Server Agent service must be running to execute jobs on schedual. Make sure the service is running and in an account that can run DTS packages. For reasons unknown or sql agent was dying and we'd need to manually restart it. To us it looked like the package ran but nothing inside the package was actually executed.-----------------------SQL isn't just a hobby, It's an addiction |
 |
|
|
|
|
|
Package for imp dbf not getting exec in Job??