Clarity

  • 1.  View job schedules

    Posted Sep 18, 2017 07:18 AM

    Hello All,

     

    Is it possible to allow a user to view job schedules, without giving them right to change the schedules?

     User would like to be able to view job schedules set up for data extracts.

     

    I have added the job specific rights to the user but i think they are only used to view the logs and get notified.

    Job Failures
    Job Notifications
    Job Sharing
    Job Users

     

    Thanks and Regards,

    Sai.



  • 2.  Re: View job schedules
    Best Answer

    Posted Sep 18, 2017 07:29 AM

    You can create a NSQL portlet for the job schedules.



  • 3.  Re: View job schedules

    Posted Sep 19, 2017 12:09 AM

    Agree with urmas.

     

    And the SQL will be as simple as:

    select name, schedule_date
    from cmn_sch_jobs
    where status_code = 'SCHEDULED'

     

    The SQL will ofcourse have to be wrapped in NSQL syntax.

    You might want to cast the "schedule_date" column to a timestamp, if you are on Oracle DB.