| You might want to consider, since this will be automatic
(and perhaps you want to "set it and forget it") ...
to always look for a file you are SURE will NEVER exist
naturally / normally ... e.g. "xyz_abc_rtf_uh_duh"
Then ... you can actually do your REAL FTP manually,
whenever it suits your business ...
Suzanne ( 2Bwy
A13.32)
desk: 646-252-8663, cell: 347-907-1125
Thanks John,
I like your suggestion.
But I am supposed to not run any cron job.
So taking your suggestion and replacing the cron job with an Oracle job
could work.
What do you think about the following?
Oracle scheduled job to execute every week or
month.
FTP login script executed
Look for file on server
File not found close FTP login
logout.
;
regards
Amlan
On Feb 5, 2008 9:20 AM, john love < mindspring.com">jrlovemindspring.com> wrote:
How about a scheduled job that would "ATTEMPT" to
perform an FTP every week. The FTP would only work if the file existed on the
server but the account would be monitored as active due to the weekly attempt
of the FTP.
Cron scheduled job to execute every week or
month.
FTP login script executed
Look for file on server
File not found close FTP login
File found, perform FTP
logout.
Just a suggestion.
John Love
jrlove mindspring .com"
target=_blank>jrlovemindspring.com-------------------
"Laughter is the greatest weapon we have and we, as humans, use it the
least." - Mark Twain
----------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any
review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended recipient,
please contact
the sender and delete the material from any computer.
----- Original Message -----
Sent: 2/5/2008 12:12:48 PM
Subject: Keep alive inactive FTP user
account
Hi All
I need help to a problem I face. I have described my solution and
need some feedback if this is going to work or if any better
solutions.
I am not sure if this is going to work or just logging into FTP server
and doing a directory listing every month through a job will also
work.
Problem description:
Every three months or 6 months, FTP user account is
used to transfer a feeder file to a remote server through pl/sql packages
as
part of business. But the FTP user account
expires if inactive for three months as set in the security policy. The
security folks will not
change the security policy. My goal is to keep the FTP
user account alive even when there is no business activity.
My Solution:
I log into FTP user account every month running as
an Oracle Job and FTP a dummy file to the server.
This will ensure some activity every month and will keep
the account alive. But this also means removing the dummy file each
time.
I am sending this out to multiple groups, hoping somebody will provide
some feddback.
Thanks and regards
Amlan
--
Amlan |
