469,111 Members | 1,977 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

Sccheduled packages don't run

In SQL Server 2000, developer edition (on my desktop), I created a
complex DTS package that truncates several tables and imports fresh
data into them (from Oracle 9i). This package was scheduled and
executed by the SQL Agent with no problem. When I moved the database
to a server, the scheduled job does not run, even though I can
manually run the DTS package successfully. I've recreated the DTS
package, rescheduled the package, and tried to change properties of
the job, all to no avail. I've even uninstalled the developer edition
from my machine and installed the client software from the SQL Server
standard disk.

What do I try next???

Bill Reynolds
Jul 20 '05 #1
1 985
fn
If you can, go to the server (physically or using something like VNC)
and runs the package in the designer. My guess is that it will fail. And
if it does, it's most likely because the server doesn't have access to
something that you have defined on your machine. This could be any
number of things (mapped drive, TNS file, INI file). But you'll be able
to figure it out by determining which task fails.

FN

Bill Reynolds wrote:
In SQL Server 2000, developer edition (on my desktop), I created a
complex DTS package that truncates several tables and imports fresh
data into them (from Oracle 9i). This package was scheduled and
executed by the SQL Agent with no problem. When I moved the database
to a server, the scheduled job does not run, even though I can
manually run the DTS package successfully. I've recreated the DTS
package, rescheduled the package, and tried to change properties of
the job, all to no avail. I've even uninstalled the developer edition
from my machine and installed the client software from the SQL Server
standard disk.

What do I try next???

Bill Reynolds


Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Robert Clayton | last post: by
3 posts views Thread by Chris Barker | last post: by
reply views Thread by Matt Price | last post: by
15 posts views Thread by Nick Coghlan | last post: by
5 posts views Thread by Fuzzyman | last post: by
1 post views Thread by Mage | last post: by
2 posts views Thread by Peter Saffrey | last post: by
4 posts views Thread by Kay Schluehr | last post: by
7 posts views Thread by Oliver Elphick | last post: by
reply views Thread by giovanni gherdovich | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.