Re: Start a job based on a file being placed in a directory in the IFS

SSIS can also load a IBM DB2 for i table directly...rather than mess
with an intermediate stream file.

Charles

On Mon, Feb 6, 2012 at 11:10 AM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

Mike,
Would your script be able to determine that the upload of the file has
completed before starting?



Pat,
I will have to look into that.  It seems like a possible solution if they
are able to directly place the file on the i using MS SQL.


Thanks to all who responded.
I will look into all of the suggestions.


On Mon, Feb 6, 2012 at 10:19 AM, Mike Bardin <mike@xxxxxxxxx> wrote:

On Mon, 6 Feb 2012 09:10:28 -0500
 Jeff Young <jyoung0950@xxxxxxxxx> wrote:

All,
Is there any way to automaticaly start a job based on when a file is
placed
in a directory on the IFS?
I have a client that will be uploading a file from an external
system (MS
SQL Server) and they would like to have a batch job startup on the i
when
the file is uploaded.
I know that I can have a program monitor the directory by reading
the
directory and when the file is present, fire off the batch job, but
is
there an easier method?  If not, how can I determine that the file
upload
has completed before I start the batch job?

All suggestions will be appreciated.

Thanks,


--
Jeff Young
Sr. Programmer Analyst
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Consider such QSHELL script
(for example, with path /home/Jeff/filemonitor.sh)

# BEGIN SCRIPT
#This job sleeps 10 seconds.
#After sleeping it checks existence of IFS file
# "file-with-my-name"
# Job starts when this file exists.
# Before job start, we rename this file
# to "file-with-new-name"
# to prevent our job to start twice with a single file.
# The job must react to file with new name, and remove it
# when possible.

while [[ 0 -lt 1 ]]  #Loop forever
do
if [ -e "file-with-my-name" ]
 then
 mv "file-with-my-name" "file-with-new-name"
#start job with your favorite program in your specefic environment
 system "SBMJOB CMD(...) JOB(...)"
 echo 'Job Started'
else
 echo 'Job Not Started'
fi
sleep 10
done

#END SCRIPT

To start this monitor with name MYMONITOR

SBMJOB CMD(QSH CMD('sh /home/Jeff/filemonitor.sh')) JOB(MYMONTOR)
 --
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
Jeff Young
Sr. Programmer Analyst
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.