• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • View Scheduled Jobs with Excel

    April 19, 2016 Ted Holt

    At the recent RPG & DB2 Summit in Dallas, I presented a session that dealt with the use of SQL in CL. One of my examples used the SCHEDULED_JOB_INFO view to retrieve scheduled jobs from the IBM i job scheduler. After the talk, one of the attendees gave me a great idea, and I’ve just got to pass it along to you.

    SCHEDULED_JOB_INFO returns the same information that you can see with the Work with Job Schedule Entries (WRKJOBSCDE) command. It’s one of the IBM i Services. The gentleman told me that he and others in his shop had been working to get a handle on scheduled jobs. WRKJOBSCDE does not lend itself to analysis, and API’s are hard to work with. His idea was to use my query to build a database table, then use Copy to Import File (CPYTOIMPF) to create a CSV file, which Excel could open. The following CL code gives the general idea.

    dcl   &SqlCmd    *char    512
    
    chgvar  &SqlCmd +
       ('declare global temporary table JobInfo as +
         (select scheduled_job_name, scheduled_days, +
         next_submission_date, status, +
         description, sbmtimstmp, sbmjobsts +
         from scheduled_job_info +
         where scheduled_days like ''%*TUE%'' +
         or scheduled_days like ''%*ALL%'') +
         with data with replace')
    runsql   sql(&SqlCmd) commit(*none)
    
    cpytoimpf  fromfile(qtemp/JobInfo) tostmf(JobInfo.csv) +
                 mbropt(*replace) stmfccsid(*pcascii) +
                 rcddlm(*crlf) addcolnam(*sql)
    

    Why do I keep editing this newsletter and speaking at conferences? Because I can’t afford not to. I learn more from others than what others learn from me.

    Ted Holt welcomes your comments and questions. Email him through the IT Jungle Contacts page.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  2016 Annual Meeting & Expo, May 15 - 18, in New Orleans! Great Power Systems event!
    NGS :  Webinar: Realizing the Power of IBM i with NGS-IQ. May 11. RSVP now!
    Profound Logic Software:  'i on the Enterprise' Worldwide Virtual Event. June 8. Register Now!

    We Can Just Barely See RPG In i 7.3 Software Vendors Prep For IBM i 7.3, Applaud PDP for Testing

    Leave a Reply Cancel reply

Volume 16, Number 09 -- April 19, 2016
THIS ISSUE SPONSORED BY:

T.L. Ashford
WorksRight Software
Storagepipe

Table of Contents

  • Surge of Services in DB2 for i, Part 2
  • View Scheduled Jobs with Excel
  • Refacing Your Database, Part 2

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle