File Watcher RRS feed

  • Question

  • Hi


    There is one requirement where I am supposed to update a table in the sql database based on a job status that would be executed by a mainframe application. 


    We are planning to have the mainframe application to create a text file and to upload to some location. We will then create a windows service with file watcher, that will "watch" this folder for any change/deletion. Is this a best way?


    Instead of watching for a file, is there any other way to implement this?




    Monday, October 20, 2008 12:56 PM

All replies

  • That's the way I would do it. If you can't call a web service from the main frame.
    Monday, October 20, 2008 1:58 PM
  • The approach seems right. However, you may want to consider sending messages to MSMQ_MQ series from mainframe apps instead to a file. File approach is simple and not extensible. Queue approach is little complicated but extensible. You may choose one of them depending on your requirements. For example, if your requirement says there will never be more than one update per job, then File approach looks good, else it should be MSMQ.


    Hope this helps.





    Monday, October 20, 2008 4:02 PM
  • Do you have an Enterprise Scheduling tool. For example schedule the file from the Mainframe, then schedule the file into SQL. The scheduled job would look for a file. SFTP could be used as the mechanism to copy the file.



    Tuesday, November 4, 2008 4:45 AM