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

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

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

Generally speaking, no. May be, it is possible to create a fictive zero-length file and check existence of it - then you not need to rename the real data file via mv command. But if you connect to i via MS SQL , maybe you can execute DB2 SQL CALL PROCEDURE - see Pat's post, you can run SBMJOB command in i procedure.

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.