DTS Job running way too long

Hello,
I have a DTS package that pulls data out of an Oracle database and
inserts it into a SQL Server database for reporting. The package
executes in about 2 seconds when I run it directly (right-click on the
package and 'execute'). But when I schedule the job to run, it runs
forever and never completes. Any tips or words or wisdom from the
experts out there?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!check the accout runing your sql server to oracle!
running a job from your work station is different from running a job on
schedule.
one uses the security context of your workstation, the other uses the
security context of the box SQL is running on.
perhaps your server acct does not have rights to oracle? if there's no
timeout set for connection, it will run forever.
Steve Lin
MCDBA
"Rachael" <rachael_faber@.hotmail.com> wrote in message
news:OSk3CS0GEHA.2308@.tk2msftngp13.phx.gbl...
> Hello,
> I have a DTS package that pulls data out of an Oracle database and
> inserts it into a SQL Server database for reporting. The package
> executes in about 2 seconds when I run it directly (right-click on the
> package and 'execute'). But when I schedule the job to run, it runs
> forever and never completes. Any tips or words or wisdom from the
> experts out there?
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!