i have this Perl script "run_etl_jobs.pl". when i start a batch by updating the batch status field in a table to "START", the script should run until i stop the batch. Also, within the loop, i need to get the job names with parameters returned by stored procedure and execute the jobs parallely . once these jobs are triggered, need to update the job status to "RUNNING" and log the start time to JOB_LOG table. once the jobs are completed, update the job status to "SUCCESS" and log the end time. Also, when 5 jobs are running and i should not run any other jobs(max we can run 5 jobs at a time). i have handled this in store proc. However, My question is that i need a startup script to build this master script with this scenarios. or else if CPAN have any built in modules/packages to schedule these kind of jobs with database repository. please point that. basically i'm building a scheduler so that i can use for my project.

In reply to Re^2: Job scheduling? by laknarc
in thread Job scheduling? by laknarc

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.