Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"To YOU I'm an atheist; to God, I'm the Loyal Opposition." -- Woody Allen

computers / comp.sys.ibm.as400.misc / Re: AS/400 Query Scheduling!

SubjectAuthor
* Re: AS/400 Query Scheduling!Osvaldo de Almeida
`- Re: AS/400 Query Scheduling!saitology9

1
Re: AS/400 Query Scheduling!

<847bd435-cd3e-4e1b-802d-355cc8db1fc3n@googlegroups.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=74&group=comp.sys.ibm.as400.misc#74

  copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:622a:19a0:b0:3db:cd1b:e227 with SMTP id u32-20020a05622a19a000b003dbcd1be227mr4322015qtc.6.1680287236651;
Fri, 31 Mar 2023 11:27:16 -0700 (PDT)
X-Received: by 2002:a05:6902:18c2:b0:b78:5662:d5bb with SMTP id
ck2-20020a05690218c200b00b785662d5bbmr14113886ybb.3.1680287236316; Fri, 31
Mar 2023 11:27:16 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 31 Mar 2023 11:27:16 -0700 (PDT)
In-Reply-To: <34f54c62.1948212@news.demon.co.uk>#1/1>
Injection-Info: google-groups.googlegroups.com; posting-host=41.205.58.117; posting-account=huJUkQoAAADXqSXk-uxKDjUeaesUG9CX
NNTP-Posting-Host: 41.205.58.117
References: <6bs6ua$dov@news.inforamp.net> <34e260c7.108642070@news.lakes.com> <34f54c62.1948212@news.demon.co.uk>#1/1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <847bd435-cd3e-4e1b-802d-355cc8db1fc3n@googlegroups.com>
Subject: Re: AS/400 Query Scheduling!
From: almsvald...@gmail.com (Osvaldo de Almeida)
Injection-Date: Fri, 31 Mar 2023 18:27:16 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 3591
 by: Osvaldo de Almeida - Fri, 31 Mar 2023 18:27 UTC

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

Re: AS/400 Query Scheduling!

<u079e2$1hasd$1@dont-email.me>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=75&group=comp.sys.ibm.as400.misc#75

  copy link   Newsgroups: comp.sys.ibm.as400.misc
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: saitolo...@gmail.com (saitology9)
Newsgroups: comp.sys.ibm.as400.misc
Subject: Re: AS/400 Query Scheduling!
Date: Fri, 31 Mar 2023 14:40:01 -0400
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <u079e2$1hasd$1@dont-email.me>
References: <6bs6ua$dov@news.inforamp.net> <34e260c7.108642070@news.lakes.com>
<34f54c62.1948212@news.demon.co.uk>
<847bd435-cd3e-4e1b-802d-355cc8db1fc3n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 31 Mar 2023 18:40:02 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="1ceaf9c489dabb224d603d1447d6c52e";
logging-data="1616781"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX182Er4IBfge1hF0T2IcRXPW"
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101
Thunderbird/102.9.0
Cancel-Lock: sha1:GLSJNP5xWUy+6SkekpdyDkxc6/c=
In-Reply-To: <847bd435-cd3e-4e1b-802d-355cc8db1fc3n@googlegroups.com>
Content-Language: en-US
 by: saitology9 - Fri, 31 Mar 2023 18:40 UTC

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.

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor