Tidal and SAP jobs

[Bill Heilman]

Greetings,

I have recently moved from a Lawson/Oracle shop to an SAP shop and am in the process of reviewing a number of SAP jobs that they have time out due to a file not being present.  While I am still learning the SAP processes, I am looking for what others have done for SAP jobs that are dependent on a file that has no set arrival time/day.  I have used File Events in the past, and know that they only allow moving or deleting, but with that said, and seeing that SAP needs the file to be in a specific directory for the program to process the file, is there anyone that may be able to solve the file monitor dilemma so if the file shows up in the directory that the program is supposed to pick it up from, a way to insert the job based on that instead of just having the job 'spin it's wheels' in case the file is available?

Thanks!

Bill

[jlayton99]

Hi Bill,

The way we do this is to use a File Event to watch for the file. Put the file event on a daily schedule and leave it run. In the Associated Actions tab, define a Job action to take. In our case, it's to load a group of jobs into the schedule.

The group of jobs only runs once the file is detected.

Hope this helps.

Jarrod

[Bill Heilman]

Hi Jarrod,

Thanks for the reply.  I have used File Events to trigger jobs and groups.  The issue at hand is this;  1) the user run SAP job creates a file in an ~/ocom directory.

2) the scheduled SAP job in Tidal that needs to run based on the file presence needs to read the file from the ~/ocom directory

3) the issue becomes that with a File Event, the only options are to delete or move the file.  We can't move the file because the SAP job needs it in that directory to run, and for obvious reasons, we can't delete it.

I'm just looking for options without looking to 're-jigger' any SAP jobs to create even a flag file when the user job is done as we have hundreds of these.

Thanks!

Bill