Home > IT Answers > Database > Iseries Queries.
Querys
100 pts.
 Iseries Queries.
Access Database, AS/400 queries, AS/400 scheduling, Microsoft Access
Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change it so I get it only Monday thru Friday on a daily basis? thanks

Software/Hardware used:
ASKED: January 12, 2009  7:06 PM
UPDATED: January 13, 2009  11:37 AM
RELATED QUESTIONS
Answer Wiki:
Hi, I assume you've got this scheduled using the WRKJOBSCDE on the AS400. If you only want the job to run MON-FRI you should change the SCDDAY parameter on the job schedule entry to be (*MON *TUE *WED *THU *FRI) instead of *ALL. Regards, Martin Gilbert.
Last Wiki Answer Submitted:  January 13, 2009  11:37 am  by  Gilly400   23,625 pts.
All Answer Wiki Contributors:  Gilly400   23,625 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _