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)

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, bvs...@usa.net (Bradley V. Stone) wrote: >On 11 Feb 1998 12:52:26 GMT, "Doug Porteous" <port...@inforamp.net>

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
bvs...@usa.net
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!"

geo...@fone-logistics.co.uk

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)