May 7, 2002 at 3:17 pm
I'm working on SQLServer7. I got a problem.
When I'm running my DTS Package it works fine; no errors.
But a job scheduled from this package fails.
I'm running a job and a package on the same machine using the same permissions.
I deleted a job and recreated it back; no luck.
Could anybody help?
Alex
May 8, 2002 at 5:23 am
Can you see the error returned from the job? Also generally these errors are permission issues (file referenced in package not accessible by SQLAgents account) or client issues (using 2000 client to schedule 7 package, you should use 7 client).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 05/08/2002 05:24:41 AM
May 8, 2002 at 7:59 am
James,
Thank you for your quick response.
Unfortunately, I cannot see any errors because a job is hanging in 'Executing Job Step 1' mode.
I even cannot see event log because this job is not finished yet.
Basically, in this package we transmitting data through the data transformation task from our Access 97 database which resides on the different Server machine to our SQLServer7 database which resides on the Server where I'm running a package (or a job).
Both servers are WinNT machines. So, I'm using the same machine to schedule a job.
Any more ideas?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply