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

If your customer is using DTS or Integration services to upload the file
from MS-SQL Server,
why not have the MS-SQL server issue a SQL call to execute the program
after it has uploaded the file?

Regards,
Pat Landrum
Senior Programmer/Analyst
Hanover County Public Schools
200 Berkley Street
Ashland, Va 23005
Email: plandrum@xxxxxxx Phone: 804.365.4658


Notice: This message or any accompanying documents may contain
confidential or privileged information of Hanover County Public Schools.
If you are not the intended recipient, disclosure, copying
or distribution is strictly prohibited by state and federal law. If you
received this
message in error, please notify the sender as soon as
possible.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Bardin
Sent: Monday, February 06, 2012 10:19 AM
To: Midrange Systems Technical Discussion
Subject: Re: Start a job based on a file being placed in a directory in
the IFS

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)