April 15, 2003 at 11:49 am
Familiar theme: Pkg runs fine within DTS. It's just a standard Server to Server data pump.
When invoked via Job, following error:
The process could not be created for step 1 of job 0xC525FE917CFDCB47A47498D44D79B25C (reason: Overlapped I/O operation is in progress).
This is the first step of the Job. I get same error when running under my security (i.e. right click, start job) or when Job is scheduled (i.e. under SQLAdmin account w SA).
Any ideas?
April 15, 2003 at 1:23 pm
Under what account are you starting the SQL Server Agent Service? You should check, that the login has access to the directory that the DTS package access.
April 15, 2003 at 4:11 pm
SORRY SORRY SORRY - this is the same old privilege problem. The SQL Agent user account does not have appropriate access. The error message threw me off.
THANK YOU FOR YOUR HELP.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply