Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: Crontab is not working

  1. #1

    Default Crontab is not working

    Hi All,

    I created a job to run my transformation and it is working good in kitchen.In order to schedule the job using crontab I created a script as brand.sh.The script is also running.My script looks like this


    cd /opt/pdi-open-3.1.0-826 && kitchen.sh /rep:dwh /user:admin /pass:admin /dir:/ /job:brand(in single line)

    and I created a crontab for this to execute as

    49 09 * * * "/opt/pdi-open-3.1.0-826/brand.sh"

    But it is not returning any records.


    Can you please point out what change I have to made to run this.

    Thanks in advance.

    preetha

  2. #2

    Default

    hi,

    Please give me a solution to my problem.

    Thanks

  3. #3

    Default

    Quote Originally Posted by preetha View Post
    hi,

    Please give me a solution to my problem.

    Thanks
    http://www.google.com/search?ie=UTF-...e+through+cron

  4. #4
    DEinspanjer Guest

    Default

    Or maybe http://www.google.com/search?hl=en&q...gh+cygwin+cron

    since you appear to be running this on Windows. You could be having trouble with the cron service.. Check to make sure that it is actually invoking the script. You could try putting logging statements in the .sh file.

  5. #5

    Default

    Quote Originally Posted by preetha View Post

    49 09 * * * "/opt/pdi-open-3.1.0-826/brand.sh"
    Daniel-

    How do you know she runs Cygwin on MSWindows?

    If she uses the AT command, she may use double-quotes but her syntax is off for AT command.

    I have never seen double-quotes in a typical *nix CRON job.
    Last edited by acbonnemaison; 12-19-2008 at 01:47 PM.
    Pentaho Data Integration CE 5.3.0.x
    JDK 1.7
    OS X Yosemite version 10.10.x
    MySQL 5.5.37
    Amazon Redshift
    Pacific Standard Time

  6. #6
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Preetha,

    I assume from your post in http://forums.pentaho.org/showpost.p...60&postcount=1 that you are trying to schedule this on your production system.

    There are some "Gotchas" with running commands in Unix.
    I would recommend getting your Unix admin involved with this, or possibly getting a support contact with Pentaho

    That being said, since you are not redirecting your output from the call to kitchen.sh there should be output (it writes a fair bit of output even when it fails) which will likely be in the user's mail. (ie. if this cron is being done under a user "pdi" then look in pdi's mail) That log should provide a bit of assistance in figuring out what needs to be done to fix it.

    Hope that helps!
    Last edited by gutlez; 12-19-2008 at 02:51 PM.

  7. #7
    Join Date
    Jun 2007
    Posts
    50

    Default

    An easier and more proper way to scheduke a PDI job, would be to use the built in scheduler in the START step of the Pentaho Job, then submit the job to the Carte ETL Server.

    Of course you would need to have the Carte ETL Server running. Which is common in many ETL instances.

    With the Pentaho EE version you get a Admin Console to monitor, and administer your ETL jobs as well as view logs and performance statisics in an easy to use web based console.

    Why make things more difficult with cron?

  8. #8
    DEinspanjer Guest

    Default

    Probably because the people who spend countless hours in these forums are used to this being the answer:
    http://forums.pentaho.org/showpost.p...63&postcount=2

    Granted, maybe things are improving with the Admin Console in the EE version, I haven't had a chance to play with a working version yet, but cron works and it is what many savvy administrators are used to.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.