Greetings All,

I have one script that i am able to execute as a DTS package. When I
schedule and run as a Job..no result!

The script is a batch file that retrives a .txt from my ftp site and
copies onto my local machine...any idea why it wouldn't work as a
Scheduled Job? All my other packages work seemlessly.

Here's the batch:

open mydomain.com
myusername
mypassword
cd public/catalog/
get myfile.txt
\\myroot\myfolder\myfile.txt
disconnect
quit

Thank you in advance,
Don Larry


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Make sure that the account that the SQL Server Agent is running under has
access to the batch file, and has access to the place the downloaded file is
going to.

--
Denny Cherry
DBA
GameSpy Industries
"don larry" <donlarry17 (AT) hotmail (DOT) com> wrote

Hi Denny,

The account under SQL Server Agent is the same i'm using, and i have
explict access to the file and the folder it's writing in....any other
possibilities?

Alex



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Do you get any output at all from the batch file?

--
Denny Cherry
DBA
GameSpy Industries
"don larry" <donlarry17 (AT) hotmail (DOT) com> wrote

Hi Denny,

The account under SQL Server Agent is the same i'm using, and i have
explict access to the file and the folder it's writing in....any other
possibilities?

Alex



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Denny,

The account under SQL Server Agent is the same i'm using, and i have
explict access to the file and the folder it's writing in....any other
possibilities?

Alex



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No, the file is left unchanged, data is not being refreshed..Th job
doesn't fail, it shows "success", but no output!

A question: is there a better way to schedule the execution of a batch
file? i.e. if SQL doesn't want to schedule, how else to do it?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can schedule it to run directly under a job, with out the DTS package.
Or you can schedule the batch file to run with the Scheduled Tasks icon in
the Control Panel.

--
Denny Cherry
DBA
GameSpy Industries
"don larry" <donlarry17 (AT) hotmail (DOT) com> wrote