Enterprise Job Scheduling & Lawson (TIDAL)

 5 Replies
 1 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
Garth Gerwing
Basic Member
Posts: 27
Basic Member
    We are currently using TIDAL as an enterprise job schedular. We would like to also use it to trigger and manage Lawson jobs - whereby we can manage timing and dependencies between Lawson jobs and non-Lawson jobs.

    NOTE: am aware that TIDAL has an extension product of: Lawson Enterprise Adaptor

    Does anyone have experience with either:
     - usage of the TIDAL Lawson Enterprise Adaptor - costs, effectiveness, complexity?
     - interfacing between TIDAL and Lawson without the use of the above adaptor?

    Any feedback would be most appreciated - thanks.
    Woozy
    Veteran Member
    Posts: 709
    Veteran Member

      Hi Garth - We don't use TIDAL and I have zero knowledge of it, but we use Control-M as our enterprise scheduler for almost all of our Lawson processes including S3 batch jobs, S3 ProcessFlows, LTM async tasks, and LTM ProcessFlows. 

      Control-M basically just gives us the ability to run tasks from the command line.  If TIDAL does the same thing, then this should work for you.

      We've created a small number of scripts that call the lawson command-line utilities.  Generally our scripts launch a process, then watch until it completes or errors, then notify a distribution list that it completed or failed.

      We have scripts for:
      - launching S3 batch programs (jqsubmit/wtsubmit)
      - watching for S3 batch completion/error (jqstatus)
      - launching S3 processflows (fileclient)
      - watching for S3 pflow completion (rngdbdump against LOGAN>wfworkunit)
      - launching LTM processflows
      - launching LTM async tasks

      Basically, we create ControlM jobs that call the appropriate script(s) and pass in the required parameters for program, user, job, etc.

      Since S3 provides dedicated command-line tools for these tasks, this is pretty straightforward.  LTM is more complicated because they don't provide those types of utilities, so we had to fake the system to do what we needed it to do.

      Good luck.

      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      Garth Gerwing
      Basic Member
      Posts: 27
      Basic Member
        Thanks for the timely response, Kelly.

        Process Flow and LTM don't factor-in to our scenario (just S3 batch jobs) - so it would appear we are good-to-go. Next steps for us, then, is to investigate the scripting capabilities of TIDAL - and I am pretty sure that we can get this going with a little tinkering.

        Very much appreciate the feedback.
        LauraP
        Advanced Member
        Posts: 28
        Advanced Member
          Hi Garth -

          We've been using Tidal now for the majority of our Lawson processing for almost 2 years. We use the Lawson adapter and it works quite well. We have alot of Visual Basic processes, .NET processes and PL/SQL Stored Procedures that need to be run in conjunction with the Lawson jobs so Tidal has worked really well in stringing all the pieces together.

          We have even used email to trigger the execute of a job (Tidal looks for a specific value in the Subject Line).

          If you'd like to discuss it further - I'd be happy to talk with you by phone and I could get our head BIS Job Scheduler to meet as well - he set the majority of the processing up and is VERY familiar with Tidal and it's tie to Lawson.

          Feel free to email me directly at lpatena@yankeecandle.com

          - Laura
          Garth Gerwing
          Basic Member
          Posts: 27
          Basic Member
            Hey Kelly,

            I know it has been awhile RE this - but I have just now got my hands on a TIDAL DEV environment - and want to enact some "Proof-Of-Concept" testing RE this.
            As I previously mentioned - it's only the S3 batch-related aspects that concern us - so, as per above:
               - launching S3 batch programs (jqsubmit/wtsubmit)
               - watching for S3 batch completion/error (jqstatus)

            I was wondering if it would be at all possible for you to shoot me an example of your script(s) for each of the above? This would really allow me to hit the ground running. Appreciate your time and consideration of this matter.  My direct email = ggerwing@wcb.mb.ca

            Garth

             
            Kimm
            Basic Member
            Posts: 5
            Basic Member
              Hi All,

              We are looking into this same idea for our Infor 10 install. As with Garth, this would just be for S3 batch programs and tokens (importdb and GL165). We're moving to ActiveBatch from TIDAL. Can anyone provide example scripts for how they're accomplishing this?