Define query without WRKJOBSCDE

Querys

100 pts.

Tags:

AS/400 jobs

AS/400 Query

Work with Query

WRKQRY

How can I Define a query to run only Monday thru Friday not using WRKJOBSCDE (we have a customised WRKQRY) scheduler and doesn't have an option to input the schedule day e.g. *Mon *Tues =, etc....I'll like to see if any one knows how to Define the query using the DEFINE RESULTS FIELDS e.g. YESTERDAY TODAY - 4 day but, for a week using only MON,TUE,WED,FRI only. thanks

Asked: January 13, 2009 10:57 PM Last updated: August 26, 2013 3:35 PM

Answer Wiki

Last updated: August 26, 2013 3:35 PM GMT

Ben Rubenstein11,255 pts.
History
Contributors
- Ordered by most recent
- Ben Rubenstein11,255 pts.
- taekwondo90 pts.

Thanks. We'll let you know when a new response is added.

Create a CL to run the query, make a job schedule entry to run the CL on Monday – Friday.

Discuss This Question: 2 Replies

philpl1jb Jan 14, 2009 2:11 PM GMT

Not an answer -- but .. I don't think so. You could use something like you've described to eliminate the selection of all rows on Saturday and Sunday but the query would still run and create a spool file with headings (or an empty physical file if you're selected file output) If you're scheduler could call a CL program, then the CL could evaluate the day and only run the query on selected days. Phil

54,090 pointsBadges:

report
Teandy Jan 15, 2009 8:05 PM GMT

I don't understand what having a customized WRKQRY command has to do with WRKJOBSCDE. What happens when you use the WRKJOBSCDE command? Does the job run only once or does it run every day? If it runs every day, then try the following: Create a CL that checks the day of the week. If it is between Monday and Friday, run the query. Let it run every day. PGM DCL VAR(&WEEKDAYNAM) TYPE(*CHAR) LEN(4) VALUE(' ') RTVSYSVAL SYSVAL(QDAYOFWEEK) RTNVAR(&WEEKDAYNAM) IF COND(&WEEKDAYNAM = '*MON' *OR &WEEKDAYNAM = + '*TUE' *OR &WEEKDAYNAM = '*WED' *OR + &WEEKDAYNAM = '*THR' *OR &WEEKDAYNAM = + '*FRI') THEN(RUNQRY QRY(MYQUERY)) ENDPGM Other wise you can use the SBMJOB command to schedule the job to run on a specific date and time for each date you want the job to run.

5,860 pointsBadges:

report