471,893 Members | 1,438 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.