×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On Tue, Aug 13, 2024 at 11:25 AM Art Tostaine, Jr. <atostaine@xxxxxxxxx> wrote:
We use SQL
SELECT *
FROM QSYS2.SCHEDULED_JOB_INFO
where *upper*(command_String) like '%mycommand%'
or scheduled_job_name like '%myname%'
ORDER BY SCDJOBNAME
This is one of those SQL services that is a game-changer. Most of us
have probably been where OP was, manually hunting through WRKJOBSCDE.
At my previous job, we tried to maintain a shared spreadsheet with
that information, but you can guess how that went. Ultimately, the
most effective measure we had for improving searchability was naming
convention, as limited as that was.
Nowadays, I think the first place to check when you are looking for an
easier way to do the equivalent of an interactive green-screen command
is the SQL services:
https://www.ibm.com/support/pages/ibm-i-services-sql
John Y.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
