1. Forum
  2. Usenet
  3. COMP.SYS.IBM.AS400.MISC

  • Re: AS/400 Query Scheduling!

    From saitology9@21:1/5 to Osvaldo de Almeida on Fri Mar 31 14:40:01 2023
    On 3/31/2023 2:27 PM, Osvaldo de Almeida wrote:
    Hello Guys,

    I need your support.

    I want to create auto scheduled query. Which commands or tools can I use ?

    Regards

    Osvaldo de Almeida


    Hello,
    Saitology.com has tools that do this nicely on AS/400, iSeries, IBMi.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Osvaldo de Almeida@21:1/5 to All on Fri Mar 31 11:27:16 2023
    Em sexta-feira, 20 de fevereiro de 1998 às 09:00:00 UTC+1, George Keys escreveu:
    Use addjobscde to create an entry to run a query see example below:-
    Job name . . . . . . . . . . . . > BACKCHECK1 Name
    Entry number . . . . . . . . . . > 000038 000001-999999, *ONLY
    Command to run . . . . . . . . . SBMJOB CMD(RUNQRY QRY(SCDQRY/BACKCHECKS)) Frequency . . . . . . . . . . . *WEEKLY *SAME, *ONCE, *WEEKLY...
    Schedule date, or . . . . . . . *NONE Date, *SAME, *CURRENT...
    Schedule day . . . . . . . . . . *MON *SAME, *NONE, *ALL, *MON...
    *TUE
    *WED
    *THU
    *FRI
    + for more values *SUN
    Schedule time . . . . . . . . . '22:00:00' Time, *SAME, *CURRENT

    The baove example runs at 10pm every mon tue wed thu fri and sun.
    Hope this Helps.
    On Thu, 12 Feb 1998 02:39:22 GMT, [email protected] (Bradley V. Stone) wrote: >On 11 Feb 1998 12:52:26 GMT, "Doug Porteous" <[email protected]>
    wrote:

    I'm working on a project that - in its current state - uses SQL Pass-Through
    (Rumba ODBC driver) from within Microsoft Access to submit some 30 or so >>queries. The queries do not run in parallel, since the Access application >>must submit a single query and wait for the query to complete before >>submitting the next query.

    We are running into some issues with the total time required to run all of >>the queries, and are looking at recreating the queries on the AS/400 so that
    we can benefit from queued, concurrent query execution.

    I'm aware that it is possible to schedule a query to run at a specific time >>via the "built-in" Query facility on the AS/400, but is there any way to >>schedule a query to execute, say, EVERY day at 6 p.m., or every Saturday and
    Sunday at 3 p.m.?

    Thanks in advance.
    --Doug



    Look into job scheduled entries. WRKJOBSCDE


    Bradley V. Stone
    [email protected]
    http://prairie.lakes.com/~bvstone/
    1992 Yamaha FJ1200
    1969 Suzuki T250
    "Why is he sweating? I'm not sweating and I'm wearing a turtleneck! You're fired!"
    [email protected]
    Hello Guys,

    I need your support.

    I want to create auto scheduled query. Which commands or tools can I use ?

    Regards

    Osvaldo de Almeida

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)