Skip to Content
author's profile photo Former Member
Former Member

Share any useful job monitor filters you might have created

Here are two filters I've created to make my life easier. Hopefully others will find them useful. Please post any you find useful or any improvements/corrections to any shown in this thread.

To create a filter in Redwood Explorer select Monitor -> Jobs -> New Filter, specify a name for your filter and select any Conditions you want to apply, then Save.

-


Name: Now and next 4 hours

Purpose: Displays what's running now, what is scheduled for the next 4 hours, and in case the RFC connections aren't running it shows their state

Condition: "Advanced Filter Options"

Where Clause: status IN ('SCHEDULED','RUNNING','REMOTE','WAITING') AND

requesttime < (sysdate + 4/24) OR

name LIKE '%checked%poll%'

-


Name: Jobs scheduled during weekend outage

Purpose: Displays what jobs are scheduled between the specified dates to help assess impact of outage on batch schedule

Condition: "Advanced Filter Options"

Where Clause: status IN ('SCHEDULED','RUNNING','REMOTE') AND

requesttime > to_date('20081010 1600','YYYYMMDD HH24MISS') AND

requesttime < to_date('20081013 0700','YYYYMMDD HH24MISS') OR

name LIKE '%checked%poll%'

-


Edited by: Guy Tew on Oct 8, 2008 8:19 PM

Edited by: Guy Tew on Oct 8, 2008 10:02 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2008 at 01:19 PM

    Hi Guy,

    two useful filters. Only comment I would add on the second filter is that you might also want to look at the job forecasting in CPS. A filter of jobs at the weekend is only going to show you jobs that are already scheduled. For example if I was looking at the jobs captured by this filter today (Thursday) I will see only those jobs that are already sat there ready. It's not going to show me now the jobs that I have scheduled to run later today or tomorrow that might also once complete reschedule themselves for during any outage too. Since these jobs are repeating jobs that use a submit frame and possibly a timewindow the forecasting in CPS would enable you to see these jobs too. By default these forecasted jobs are only visible in the job monitor if you enable the calendar view (button). Alternatively I have created Scripts to output the forecast into Excel to enable other non-cps users to see the impact of any outage.

    Regards,

    Simon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Guy,

      just for completeness for others, in order to do the forcasting the forcasting module needs installing which will create a couple of extra scripts that can be executed to generate a forecast. Forecasting is not enabled out of the box. You will need to run the forecast job first to see what will run in the future in the calendar view in the job monitor.

      Regards,

      Simon

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.