March 20, 2008 at 3:28 pm
I'm trying to setup a DTS scheduled job on a server thats not on my local disk, and can't get the schulded job to work. I've had the job working when it was on my local disk, but once I try to schedule the job on a different server the job always fails. I have no idea how to go about correcting this. please help.
March 20, 2008 at 3:59 pm
What is the storage format of your DTS?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 20, 2008 at 4:22 pm
I have no idea. How would I find that out?
March 20, 2008 at 4:30 pm
Well, I am going to assume that it is a local package (as opposed to say, a file). What is the error that it is returning?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 20, 2008 at 4:57 pm
This is the error message I was given under the job history popup box.
The job failed. The Job was invoked by Schedule 42 (TICKETLOGBATCH). The last step to run was step 1 (TICKETLOGBATCH).
March 20, 2008 at 8:54 pm
The prinicpal difference between running in development and running in production for a DTS package is where it runs.
In development, it typically runs on your desktop, however, in production when running from the Agent, it is actually running on the server.
So, step 1 is to actually log on to the server (either at the console or through Remote Desktop) and try to get it to work. You will probably find that there are files, dlls and directories that are missing or in a different place. so you may have to move or copy a lot of stuff around to get it to work.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2008 at 9:50 am
thank you for your time. I'll keep digging.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply