Monitoring Jobs

Overview: Job Monitoring provides the ability to monitor jobs to ensure that they are running correctly.

The Job Monitor:

Collects monitoring information, such as:

Last heartbeat date/time: the last date and time when the system verified the job was running.

Last transaction date/time: the last date and time when a transaction was processed by the job.

The system collects the monitoring information in the Job Monitor Status table. You can review the monitoring information on the Work with Job Monitor Screen (WJMO). Note: If you use multiple application servers, the system collects monitoring information in the Job Monitor Status table across all application servers.

Performs an action when job monitor rules you set up for a job are met, such as:

• receiving an email so that you can react to the condition.

• running a periodic function. For example, you can define a job monitor rule that if the Controlling Async goes down, to run the periodic function that starts the Controlling Async. If you define a periodic function, you can also have the system notify you by email if the condition for the job monitor rule still exists after running the periodic function.

The monitor rules defined for a job can be based on the last update date and time, the last transaction date and time, or query results.

You can define monitor rules for a job on the Work with Job Monitor Rules Screen. When you schedule a job monitor rule, the rule becomes a scheduled job that you can review on the Scheduled Jobs screen. Whenever you restart Order Management System Cloud Service, the system determines if any job monitor rules should be running, and if so, starts them.

Additional Job Monitoring

• The Long Running Jobs Monitor watches the batch jobs running on the Job Management Screen and sends a Long Running Job Email to a specified email address if a job runs without ending longer than a specified time. See Long Running Jobs Monitor for more information on this process and the setup requirements.

Running a Periodic Process on Server Startup provides the ability when you restart Order Management System Cloud Service (see Restarting Order Management System) for the system to look at the settings in the Monitor Property Settings to determine the periodic process and its assigned periodic functions to run on server startup. See Running a Periodic Process on Server Startup for more information about this process and the setup requirements.

In this chapter:

Job Monitor Setup

Which Jobs are Monitored?

Job Monitor Examples

Work with Job Monitor Screen (WJMO)

Work with Job Monitor Rules Screen

Create Job Monitor Rule Screen

Job Monitor Setup

Before you can use the Job Monitor, you must complete the required setup.

Monitor Properties

Job Monitor Rules

Job Monitor Queries

Monitor Properties

The Monitor Properties in Working with Admin Properties (CPRP) contain the settings required to enable the Job Monitor.

Property Name

Description

ALLOW_JOB_ MONITOR

Indicates whether you wish to run the job monitor.

Valid values:

Y = Run the job monitor.

N (default) or blank = Do not run the job monitor. In this situation, the only option on the Work with Job Monitor Rules Screen is to display a rule’s settings.

Note: Set this value to Y for all application servers.

JOB_MONITOR_QUERY_ DIRECTORY

The directory on the application server where you store queries used by the job monitor.

An example directory is /domain/conf/OMSFiles/JobMonitorQueries/, where domain is the WebLogic domain directory for Order Management System Cloud Service.

TRACK_ALERTS_IN_LOG

Indicates whether you log all alerts generated by the job monitor.

Valid values:

Y = Log all alerts generated by the job monitor in the Alert Log.

N or blank = Do not log alerts generated by the job monitor.

TRACK_ALERT_ EMAILS_IN_ FOLDER

The directory on the application server where the system stores a copy of the alert emails generated by the job monitor.

This directory is not delivered; an example location is /domain/conf/OMSFiles/JobMonitorEmails/, where domain is the WebLogic domain directory for Order Management System Cloud Service.

Each alert email is stored in this directory using the following naming convention: ALERT_JOBNAME_RULENAME_DDMMYY_HHMMSS.txt, where:

JOBNAME is job monitor name

RULENAME is the job monitor rule name

DDMMYY is the date the email alert was sent

HHMMSS is the time the email alert was sent

Example: ALERT_BILL_ASYNC_BILLASYNCACTIVE_032713_083000 indicates the email alert was generated for the BILL_ASYNC job monitor and BILLASYNCACTIVE job monitor rule on March 27 at 8:30.

Note: The system does not save an alert email in this directory if the job monitor rule name contains any special characters.

Job Monitor Rules

Use the Work with Job Monitor Rules Screen to define monitor rules for a job. For each rule, you can define:

• how often the system evaluates the rule to determine if its condition is met.

• whether the system uses the last update date and time, the last transaction date and time, or query results to determine whether to act on the rule.

• the type of action to perform if the rule’s conditions are met, such as:

- receiving an email so that you can react to the condition.

- running a periodic function. For example, you can define a job monitor rule that if the Controlling Async goes down, to run the periodic function that starts the Controlling Async. If you define a periodic function, you can also have the system notify you by email if the condition for the job monitor rule still exists after running the periodic function.

Job Monitor Queries

Create any queries for which you wish to receive an alert if the query results come back true. Once you create the query:

• Store these queries in the directory defined for the JOB_MONITOR_QUERY_ DIRECTORY property.

• Create a job monitor rule for the Query job monitor on the Work with Job Monitor Rules Screen. For this job monitor rule:

- Select to Alert On Query and enter the name of the query that you created.

- Define a schedule when the system determines if the query results come back true.

- Define the action to take if the query results come back true.

Job Monitor Query Examples

Job Monitor Rule

Query Example

receive an alert when the number of records in the billing data queue is equal to or greater than 100

select 'Y' from dual where (Select COUNT(*) from Billing_Header_Data_Queue )>=100

receive an alert if the number of running jobs for the INVTRAN_IN integration layer job is not equal to 3

select 'Y' from dual where (Select COUNT(*) from JenasysJob where jobName in (select ilq_job_name from Integration_Process_Queue where ILP_Process='INVTRAN_IN' and ILQ_Enabled='Y') and status='RUN')=3

receive an alert if no orders were created for the current date

select 'Y' from dual where (select COUNT(*) from Order_Header where CMP_Company=555 and OHD_Order_date=FNSYNONDATE)>0

Which Jobs are Monitored?

The table below lists the jobs you can monitor on the Work with Job Monitor Screen (WJMO). For each job, this table lists:

• The name of the job.

• The type of information collected for each job.

- Heartbeat Only = the job is associated with a heartbeat that the system uses to verify that the job is still active. Currently, there are no jobs associated with a heartbeat only.

- Transactions Only = the job processes transactions.

- Heartbeat and Transactions = the job is associated with a heartbeat and processes transactions.

- Query = the job runs queries not related to the other jobs listed on the Work with Job Monitor screen.

• When the system collects the type of information.

• The purpose of the job.

• The menu option where you can work with the job.

Note:

• If you have the same job running more than once; for example, you have multiple Billing Async jobs running at the same time, the job displays on the Work with Job Monitor Screen (WJMO) only once.

• If you have the same integration layer job running more than once; for example, you have multiple stored value card activation jobs, each job displays on the Work with Job Monitor Screen (WJMO).

Job

Information Collected

Updated When

MBJC

Use Background Job Control (MBJC) to review and work with these jobs.

BILL_ASYNC background job

Processes updates related to shipments and returns.See Working with the BILL_ASYNC Job.

Heartbeat and Transaction date/time

Heartbeat date/time

The job reads the billing async data queue every 30 seconds.

Transaction date/time

The system reads a record from the billing async data queue.

Note: The system also updates the heartbeat date/time and transaction date/time when you end the asyncs.

CNTL_ASYNC background job

Starts and ends each of the background ASYNC jobs. When you start the CNTL_ASYNC job, all of the background ASYNC jobs start; when you end the CNTL_ASYNC job, all of the background ASYNC jobs end. You cannot start or end an individual background ASYNC job.See Working with the CNTL_ASYNC Job.

Heartbeat and Transaction date/time

Heartbeat date/time

The job reads the controlling async data queue every 30 seconds.

Transaction date/time

The system reads a record from the controlling async data queue.

Note: The system also updates the heartbeat date/time and transaction date/time when you end the asyncs.

EBO_ASYNC background job

Updates the system tables with reservation and backorder information whenever the inventory level for a backordered item increases. Inventory levels for an item increase when you process inventory transactions, receive purchase orders, or transfer merchandise from suspense.See Working with the EBO_ASYNC Job.

Heartbeat and Transaction date/time

Heartbeat date/time

The job reads the EBO async data queue every 30 seconds.

Transaction date/time

The system reads a record from the EBO async data queue.

Note: The system also updates the heartbeat date/time and transaction date/time when you end the asyncs.

ORDR_ASYNC background job

Updates the system tables with order and demand information as orders are entered and maintained.See Working with the ORDR_ASYNC Job.

Heartbeat and Transaction date/time

Heartbeat date/time

The job reads the order async data queue every 30 seconds.

Transaction date/time

The system reads a record from the order async data queue.

Note: The system also updates the heartbeat date/time and transaction date/time when you end the asyncs.

OTHR_ASYNC background job

Updates the system tables with purchase order information when purchase orders are entered, maintained, or received.See Working with the OTHR_ASYNC Job.

Heartbeat and Transaction date/time

Heartbeat date/time

The job reads the other async data queue every 30 seconds.

Transaction date/time

The system reads a record from the other async data queue.

Note: The system also updates the heartbeat date/time and transaction date/time when you end the asyncs.

APIs

CUSTIN CWCustomer web service

Processes an Inbound Customer Message (CWCustomerIn) received from an external system, such as a point-of-sale system.

Transactions Only date/time

Transaction date/time

The CWCustomer web service processes a CWCustomerIn message.

EMAILREQ CWEmailRequest web service

Processes an Email Request Message (CWEmailRequest) received from an integrated point-of-sale system.

Transactions Only date/time

Transaction date/time

The CWEmailRequest web service processes a CWEmailRequest message.

MANIFEST CWManifest web service

Processes a Manifest Pick Request Message (CWManifestPickRequest) and Manifest Ship Request Message (CWManifestShipRequest) received from a PC manifesting station.

Transactions Only date/time

Transaction date/time

The CWManifest web service processes a CWManifestPickRequest or CWManifestShipRequest message.

ORDERINAPI CWOrderIn web service

Processes an Inbound Order XML Message (CWORDERIN) received from an external system, such as a web storefront.

Transactions Only date/time

Transaction date/time

The CWOrderIn web service processes a CWOrderIn message.

PICKINAPI CWPickIn web service

Processes a CWPickIn XML Message received from a warehouse management system.

Transactions Only date/time

Transaction date/time

The CWPickIn web service processes a CWPickIn message.

RECEIPTIN CWReceiptIn web service

Processes a PO Receipt In XML Message (CWReceiptIn) received from a warehouse management system.

Transactions Only date/time

Transaction date/time

The CWReceiptIn web service processes a CWReceiptIn message.

WPBJ

Use Working with Drop Ship Background Jobs (WPBJ) to review and work with this job.

COLLAB

Processes transactions between Order Broker’s Drop Ship Manager and Order Management System Cloud Service in the Order Broker Drop Ship Integration.

Heartbeat and Transaction date/time

Heartbeat date/time

The job looks for transactions to process, based on the Delay Time defined for the job.

Transaction date/time

The job processes a transaction.

IJCT

This list includes:

• any outbound integration layer job that has program ILR0022 defined as its Outbound program, including any jobs that you create.

• specific inbound integration layer jobs:

- CUSTHIST

- CUSTSRCH

- INV_INQUIRY

- INVTRANIN

- ORDLINHIST

- ORDTRNHIST

- PROCESSIN

- RETURNIN

Use Working with Integration Layer Processes (IJCT) to review and work with these jobs.

BILL_UPD

At periodic intervals, processes deferred billing updates for records in the Invoice Header table whose Process Date field is 0. The Outbound delay time defines how often the job processes the deferred billing updates. Example: If the Outbound delay time is 60, the system looks for deferred billing updates to process every 60 seconds.See Delay Billing Updates (K85) for processing details.

Heartbeat and Transaction date/time

Heartbeat date/time

The BILL_UPD job reads the IL Outbound Trigger table, based on the Outbound delay time defined for the job.

Transaction date/time

The BILL_UPD job processes a billing transaction.

BROKER

Sends and receives order information and updates using Order Broker’s message formats; see Sample Order Broker Messages for examples.

Heartbeat and Transaction date/time

Heartbeat date/time

The BROKER job reads the IL Outbound Trigger table, based on the Outbound delay time defined for the job.

Transaction date/time

The BROKER job processes a broker transaction.

CUST_OUT

Generates an outbound CWCustomerDownload XML message when you create, change, or delete a customer. See Generic Customer Download API for an overview.

Heartbeat and Transaction date/time

Heartbeat date/time

The CUST_OUT job reads the IL Outbound Trigger table for CST customer download triggers, based on the Outbound delay time defined for the job.

Transaction date/time

The CUST_OUT job reads and processes a customer download trigger record in the IL Outbound Trigger table.

CUSTHIST

Receives a CustHistRequest for customer order history or information on a specific order, and generates a response (CWCUSTHISTOUT or CWORDEROUT). See Generic Customer History API for an overview.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

CUSTSRCH

Receives a CWCustomerInqRequest for information on one or more customers matching specific search criteria, and generates a CWCustomerInqResponse. See Generic Customer Inquiry (Search) API for an overview.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

INV_DOWNLOAD

Sends inventory availability information to another system in the CWInventoryDownload message. See Generic Inventory Download API for an overview.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

INV_INQUIRY

Receives a CWInventoryInquiryRequest for inventory availability on a specific item/SKU and generates a CWInventoryInquiryResponse. See Generic Inventory Inquiry API for an overview.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

INVOIC_OUT

Sends invoice information in the CWInvoiceOut message to another system, such as a retail store, financial system, or warehouse management system. See Generic Invoice Download API for an overview.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

INVTRANIN

Receives inventory transactions in the inCreateInvXaction message and updates inventory information, such as in the Item Location and Item Warehouse tables. Any errors create Item Transaction Error records. See Generic Inventory Transaction Upload for an overview.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

ITEM_OUT

Sends item and SKU information in the CWItemOut message to another system, such as a retail store or warehouse management system. See Generic Item Download API.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

ORDCLNUP Order Cleanup job

Rejects any orders that have been “abandoned” on the web storefront if, for example, the customer closes the browser window. This process uses the Time Limit for Suspended E-Commerce Orders (G43) system control value to determine the number of minutes to wait before rejecting an order. Only orders of the type specified in the E-Commerce Order Type (G42) system control value are eligible for cleanup, and the cleanup takes place only if the Get Orders from E-Commerce (G35) system control value is selected. The system generates the E-Commerce Order Cleanup Log each time it deletes a suspended order. Each time the job rejects an order, it writes a record in the Deleted Order Table.

Heartbeat and Transaction date/time

Heartbeat date/time

The job looks for orders to clean up every minute. The system also updates the heartbeat date/time when the job deletes an order.

Transaction date/time

The job deletes an order.

ORDLINHIST

Receives order line history activity for a specified order line on an order, based on XML messages from an external system, such as a warehouse management system. See Order Line History In API.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

ORDTRNHIST

Receives order transaction records for a specified order, based on XML messages from an external system, such as a warehouse management system. You can review the order transaction history records created on the Display Order History Screen. See Generic Order Transaction History API.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

PICK_OUT

Sends a Pick Message from Order Management System Cloud Service (CWPickOut) for each pick slip generated. See Generic Pick Out API for an overview.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

PMD_ONLINE

Used by the Paymentech Point-to-Point Integration to open a connection to the online port defined in the Interface Properties File to connect to Paymentech to process online transactions and keeps the online connection open until you end the PMD_ONLINE job.

Note: This setting is not currently implemented.

Heartbeat and Transaction date/time

Heartbeat date/time updated by completing an online authorization transaction then sleeping for 2 seconds.

Transaction date/time updated every time the PMD_ONLINE job processes a Paymentech transaction.

PO_OUT

Sends a CWPurchaseOrderOut message to a warehouse management system or an EDI vendor. See Generic Outbound Purchase Order API.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

PROCESSIN

Uses the CWServiceIn Web Service to receive the CWProcessIn message and submit the specified periodic process received from an external system.

Transactions Only date/time

Transaction date/time updated when the CWServiceIn web service receives and processes a CWProcessIn message.

RETURN_OUT

Sends a Return Authorization Outbound XML Message (CWReturnRAOut) when a return authorization is created, changed, or deleted. See Outbound Return API for an overview.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

RETURNIN

Receives an Return Request Message (CWReturnIn) to create and process a return against a specified order line. Optionally, the process sends an Return Response Message (CWReturnOut) to the external system, indicating if the return processed successfully or if an error occurred. See Inbound Return API for an overview.

Transactions Only date/time

Transaction date/time updated when the job receives and processes a transaction.

SVC_OUT

Sends a Stored Value Card Activation Request to a service bureau. The service bureau returns a Stored Value Card Activation Response to Order Management System Cloud Service. See Stored Value Card Purchase and Activation.

Heartbeat and Transaction date/time

Heartbeat date/time updated by completing a stored value card activation transaction then then sleeping for 2 seconds.

Transaction date/time updated every time the SVC_OUT job processes an activation transaction.

SVC_REVRSL

Sends a Stored Value Card Authorization Reversal to the service bureau. The service bureau sends a Stored Value Card Authorization Reversal Response to Order Management System Cloud Service. See Stored Value Card Authorization Reversal.

Heartbeat and Transaction date/time

Heartbeat date/time updated by completing a stored value card authorization reversal transaction then sleeping for 2 seconds.

Transaction date/time updated every time the SVC_REVRSL job processes an authorization reversal transaction.

VENDOR_OUT

Sends a CWVendorOut message to another system, such as a retail store or warehouse management system. See Generic Vendor Download API.

Heartbeat and Transaction date/time

Heartbeat date/time updated by reading the IL Outbound Trigger table. If the table is empty, the system sleeps for the Outbound delay time and then reads the table again.

Transaction date/time updated every time the system reads and processes a record in the IL Outbound Trigger table.

Query

QUERY

Runs queries not related to the jobs listed on the Work with Job Monitor screen.

Query Only

The system does not update the heartbeat date/time or transaction date/time for this job. See Job Monitor Queries for more information on how to set up the Query job monitor.

Job Monitor Examples

Job Monitor Example: PICK_OUT

Job Monitor Example: ORDER_IN

Job Monitor Example: Query

Job Monitor Example: PICK_OUT

You want to be notified by email every day between 9AM and 5PM when the system does not update the Update Date and Update Time for the PICK_OUT integration layer job, indicating the job is no longer active. The system should send an email 2 minutes after the conditions for the job monitor rule are met (the update date and update time are NOT updated), and then check every 5 minutes to see if the rule’s conditions are still met. After 10 minutes, the system should send another email.

You create a job monitor rule with the following rule settings:

Frequency: Daily

Start Time: 090000

End Time: 170000

Alert On: Update Time

Alert After: 2 minutes

Sleep Time: 5 minutes

Re-alert After: every 10 minutes

Action Type: Email

The system uses the following calculation to determine if the job monitor rule’s conditions are met: current time - alert after minutes > last update time.

At 9:02 the system checks to see if the job monitor rule’s conditions are met (the update date and time are not updated, indicating the job is not active). In this example, the PICK_OUT job is not active. The system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

The job monitor rule sleeps for 5 minutes.

At 9:07 (9:02 + 5 minutes sleep), the system checks to see if the job monitor rule’s conditions are met (the update date and time are not updated, indicating the job is not active). In this example, the PICK_OUT job is not active; however, the system does not send a job monitor rule email because the 10 minute re-alert time has not been reached.

At 9:12 (9:07 + 5 minute sleep), the system checks to see if the job monitor rule’s conditions are met (the update date and time are not updated, indicating the job is not active). In this example, the PICK_OUT job is not active. Because the 10 minute re-alert time has been reached, the system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

Job Monitor Example: ORDER_IN

You want to be notified by email every day between 9AM and 5PM when the system does not update the Transaction Date and Transaction Time for the ORDER_IN integration layer job, indicating web orders are no longer being received. The system should send an email 15 minutes after the conditions for the job monitor rule are met (the transaction date and time are NOT updated, indicating a web order was not received in the last 15 minutes), and then check every 30 minutes to see if the rule’s conditions are still met. After 15 minutes, the system should send another email.

You create a job monitor rule with the following rule settings:

Frequency: Daily

Start Time: 090000

End Time: 170000

Alert On: Transaction Time

Alert After: 15 minutes

Sleep Time: 30 minutes

Re-alert After: every 30 minutes

Action Type: Email

The system uses the following calculation to determine if the job monitor rule’s conditions are met: current time - alert after minutes > last transaction time.

At 9:15 the system checks to see if the job monitor rule’s conditions are met (the transaction date and time are not updated, indicating web orders are no longer being received). In this example, the conditions are met. The system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

The job monitor rule sleeps for 30 minutes.

At 9:45 (9:15 + 30 minutes sleep), the system checks to see if the job monitor rule’s conditions are met (the transaction date and time are not updated, indicating web orders are no longer being received). In this example, the conditions are met and the 30 minute re-alert time has been reached. The system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

Job Monitor Example: Query

You want to be notified by email every day between 9AM and 5PM when the number of unprocessed billing async records is equal to or greater than 500 records. The system should send an email 5 minutes after the query results are true, and then check every 10 minutes to see if the rule’s conditions are still met. After 30 minutes, the system should send another email.

You create the following query and place the query in the JOB_MONITOR_QUERY_ DIRECTORY:

select 'Y' from dual where (Select COUNT(*) from Billing_Header_Data_Queue )>=500

You create a job monitor rule with the following rule settings:

Frequency: Daily

Start Time: 090000

End Time: 170000

Alert On: Query

Query: BILLINGRECORDS.TXT

Alert After: 5 minutes

Sleep Time: 10 minutes

Re-alert After: every 30 minutes

Action Type: Email

At 9:05, the system checks to see if the job monitor rule’s conditions are met (the results for the BILLINGRECORDS.TXT query in the JOB_MONITOR_QUERY_ DIRECTORY are Y, indicating there are 500 or more unprocessed billing async records). In this example, the query results are met. The system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

The job monitor rule sleeps for 10 minutes.

At 9:15 (9:05 + 10 minutes sleep), the system checks to see if the job monitor rule’s conditions are met (the results for the BILLINGRECORDS.TXT query in the JOB_MONITOR_QUERY_ DIRECTORY are Y, indicating there are 500 or more unprocessed billing async records). In this example, the conditions are met and the 30 minute re-alert time has been reached. The system sends a job monitor rule email to the specified To Email address and updates the Check date and Check time for the rule.

Work with Job Monitor Screen (WJMO)

Purpose: Use this screen to review and work with the job monitor rules defined for a batch job.

How to display this screen: Enter WJMO in the Fast Path field at the top of any menu or select Job Monitor Status from a menu.

Column sort: You can sort on any column on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.

Jobs first display on this screen in alphanumeric job name sequence.

• To review the job with the most recent update, click on the Update Date field until an arrow pointing down displays next to it to display jobs in descending update date sequence.

• To review the job with the most recent transaction, click on the Transaction Date field until an arrow pointing down displays next to it to display jobs in descending transaction date sequence.

Field

Description

Job Name

The name of the job. Place your cursor over the job name to determine if the job is associated with a heartbeat and/or transactions.

Heartbeat Only = the job is associated with a heartbeat that the system uses to verify that the job is still active. Currently, there are no jobs associated with a heartbeat only.

Transactions Only = the job processes transactions.

Heartbeat and Transactions = the job is associated with a heartbeat and processes transactions.

Query = this job runs queries not related to the other jobs listed on the Work with Job Monitor screen.

See Which Jobs are Monitored? for a list of jobs that display on this screen and whether the job is associated with a heartbeat and/or transactions.

Alphanumeric, 10 positions; display-only.

Update Date

The date when a heartbeat was last processed for the job to verify that the job is still active.

If the job also processes transactions, the system also updates this field when a transaction is processed.

Note: If a job uses a heartbeat and processes transactions, the update date and time may be different from the transaction date and time.

Numeric, 8 positions (in user date format); display-only.

Update Time

The time when a heartbeat was last processed for the job to verify that the job is still active.

If the job also processes transactions, the system also updates this field when a transaction is processed.

Note: If a job uses a heartbeat and processes transactions, the update date and time may be different from the transaction date and time.

Numeric, 6 positions (HH:MM:SS format); display-only.

Transaction Date

The date when a transaction was last processed by the job.

Note: If a job uses a heartbeat and processes transactions, the update date and time may be different from the transaction date and time.

Numeric, 8 positions (in user date format); display-only.

Transaction Time

The time when a transaction was last processed by the job.

Note: If a job uses a heartbeat and processes transactions, the update date and time may be different from the transaction date and time.

Numeric, 6 positions (HH:MM:SS format); display-only.

Process

The menu option where you can work with the job.

Click on this value to advance to the specified menu option.

Rules

Indicates whether any condition rules are defined for the job.

Once rules are defined for a job, the color of the Rules icon changes to blue ().

Screen Option

Procedure

Work with the condition rules defined for a job

In the Action drop down list, select Rules for a job to advance to the Work with Job Monitor Rules Screen.

Note: Once rules are defined for a job, the color of the Rules icon changes to blue ().

Refresh the screen with the most recent Update Date, Update Time, Transaction Date, and Transaction Time

Select Refresh.

Display all jobs in the Job Monitor Status, including jobs that were previously hidden

Select Show All.

Note: You can use the Hide Job option on the Work with Job Monitor Rules Screen to hide a job so that it does not display on the Work with Job Monitor Screen (WJMO).

Work with Job Monitor Rules Screen

Purpose: Use this screen to define monitoring rules for a job. When these rules are met, you can have the system:

• notify you by email.

• run a periodic function, and if the conditions for the rule are still met after the defined sleep time, send an email when the re-alert time is reached.

The condition rules can be based on the last update date and time, the last transaction date and time, or query results.

Note: If job monitoring does not run on the application server (the ALLOW_JOB_ MONITOR property for the application server is set to N), the only option on this screen is to display a rule’s settings.

How to display this screen: In the Action drop down list, select Rules for a job on the Work with Job Monitor Screen (WJMO).

Column sort: You can sort on the Rule and Status columns on this screen by clicking on the column name. An arrow pointing up displays next to the field when the values for the field display in ascending sequence; an arrow pointing down displays next to the field when the values for the field display in descending sequence.

Field

Description

Job Name

The name of the job associated with the monitoring rules. This is the job you selected on the Work with Job Monitor Screen (WJMO).

Alphanumeric, 10 positions; display-only.

Rule

The name of the job monitor rule.

Note:

• When you schedule a job monitor rule, the system uses the first 10 positions of the rule name as the job name that displays on the Scheduled Jobs Screen.

• In order to save alert emails for the job monitor rule in the TRACK_ALERT_ EMAILS_IN_ FOLDER directory, do not use any special characters in the job monitor rule name.

Alphanumeric, 25 positions; display-only.

When

Indicates how often the system monitors the job to see if it meets the rule’s conditions, based on the Frequency, Start Time, and End Time defined for the rule on the Create Job Monitor Rule Screen.

Alphanumeric, 40 positions; display-only.

Status

The status of the job monitor rule.

Valid statuses are:

Unscheduled = The rule has been created, but it not in use.

Scheduled = The rule has been created and scheduled, but is not currently running.

Running = The rule is actively running.

Ending = The rule is in the process of ending.

Alphanumeric, display-only.

Check Date

The date when the system last compared this rule to the monitoring information for the job to determine if the rule’s conditions are met.

Numeric, 8 positions (in user date format); display-only.

Check Time

The time when the system last compared this rule to the monitoring information for the job to determine if the rule’s conditions are met.

Numeric, 6 positions (HH:MM:SS format); display-only.

If you are reviewing the Work with Job Monitor Rules screen from an application server

Screen Option

Procedure

Create a job monitor rule

Select Create to advance to the Create Job Monitor Rule Screen.

Hide this job from the Work with Job Monitor Screen (WJMO)

Select Hide Job.

Note: To redisplay this job, including all other jobs that are hidden, select Show All on the Work with Job Monitor Screen (WJMO).

Review a job monitor rule

Select Display in the Action column for a job monitor rule to advance to the Display Job Monitor Rule screen. All fields on this window are display-only. See the Create Job Monitor Rule Screen for field descriptions.

Note: This option is available if the status of the job is Unscheduled, Scheduled, Running, or Ending.

Change a job monitor rule

Note: This option is available only if the Status of the job monitor rule is Unscheduled.

Select Change in the Action column for a job monitor rule to advance to the Change Job Monitor Rule screen. See the Create Job Monitor Rule Screen for field descriptions.

Note: This option is available if the status of the job is Unscheduled.

Run a job monitor rule

Note: This option is available only if the Status of the job monitor rule is Unscheduled or Scheduled.

Select Start in the Action column for a job monitor rule to change its status to Running. At the Confirm window, select OK to start running the rule; otherwise, select Cancel.

Note: This option is available if the status of the job is Unscheduled or Scheduled and the start time is met.

When you start a job monitor rule, the system changes the status of the job to Running.

Stop a job monitor rule

Note: This option is available only if the Status of the job monitor rule is Running.

Select Stop in the Action column for a job monitor rule. At the Confirm window, select OK to stop running the rule; otherwise, select Cancel.

Note: This option is available if the status of the job is Running.

When you stop a rule, the system changes its status from Running to Ending, and then to Unscheduled or Scheduled.

Schedule a job monitor rule

Note: This option is available only if the Status of the job monitor rule is Unscheduled.

Select Schedule in the Action column for a job monitor rule to change its status to Scheduled. At the Confirm window, select OK to schedule the rule; otherwise, select Cancel.

Note: This option is available if the status of the job is Unscheduled.

When you schedule a job monitor rule, the system displays the job on the Scheduled Jobs Screen. The first 10 positions of the job monitor rule name displays as the job name on the screen. If the job monitor rule runs a periodic process, the system also displays the periodic process on the Scheduled Jobs screen and schedules the periodic process to run 1 minute after the associated job monitor rule. Once the periodic process runs, the system removes it from the Scheduled Jobs screen.

Unschedule a job monitor rule

Select Unschedule in the Action column for a job monitor rule to change its status to Unscheduled. At the Confirm window, select OK to schedule the rule; otherwise, select Cancel.

Note: This option is available if the status of the job is Scheduled.

Delete a job monitor rule

Select Delete in the Action column for a job monitor rule. At the Confirm window, select OK to delete the rule; otherwise, select Cancel.

Note: This option is available if the status of the job is Unscheduled.

Create Job Monitor Rule Screen

Purpose: Use this window to define settings for a job monitor rule.

How to display this screen: Select Create on the Work with Job Monitor Rules Screen.

Field

Description

Job Name

The name of the job associated with the monitoring rule. This is the job you selected on the Work with Job Monitor Screen (WJMO).

Alphanumeric, 10 positions; display-only.

Rule

The name of the job monitor rule.

Note: When you schedule a job monitor rule, the system uses the first 10 positions of the rule name as the job name that displays on the Scheduled Jobs Screen.

Alphanumeric, 25 positions; required.

Frequency

How often the system monitors the job to see if it meets the rule’s conditions.

Valid values:

Daily: the system monitors the job for this rule every day.

Weekdays: the system monitors the job for this rule every Monday, Tuesday, Wednesday, Thursday, and Friday.

Weekends: the system monitors the job for this rule every Saturday and Sunday.

Monday: the system monitors the job for this rule every Monday.

Tuesday: the system monitors the job for this rule every Tuesday.

Wednesday: the system monitors the job for this rule every Wednesday.

Thursday: the system monitors the job for this rule every Thursday.

Friday: the system monitors the job for this rule every Friday.

Saturday: the system monitors the job for this rule every Saturday.

Sunday: the system monitors the job for this rule every Sunday.

Alphanumeric; required.

Start Time

Defines the start time when the system monitors the job to see if it meets the rule’s conditions.

You must enter the start time in HHMMSS military format; for example, enter 070000 to indicate a start time of 7 AM.

Note: Valid entries are 000000 - 235959. The start time must be earlier than the end time.

Numeric, 6 positions; required.

End Time

Defines the end time when the system monitors the job to see if it meets the rule’s conditions.

You must enter the end time in HHMMSS military format; for example, enter 170000 to indicate an end time of 5 PM.

Note: Valid entries are 000000 - 235959. The end time must be later than the start time.

Numeric, 6 positions; required.

User

The user ID associated with the job monitor rule.

The user ID defaults to the user that is creating or updating the rule, but you can override it.

User IDs are defined in and validated against the User table.

Alphanumeric, 10 positions; required.

Alert On

Defines the factor the system evaluates to determine if the job meets the rule’s conditions.

Valid values:

Update Time: The system evaluates the job’s last update date and time to determine if the job meets the rule’s conditions.

Transaction Time: The system evaluates the job’s last transaction date and time to determine if the job meets the rule’s conditions.

Query: The system evaluates the results of the query specified for the rule to determine if the job meets the rule’s conditions.

Alphanumeric, required.

Query

The name of the query whose results the system evaluates to determine if the job meets the rule’s conditions.

The query must be located in the directory defined in the JOB_MONITOR_QUERY_ DIRECTORY property.

Alphanumeric, 25 positions; required if Alert On is set to Query.

Alert After

The number of minutes to determine when to test for the condition.

current time - alert time = last update time

Numeric, 3 positions; required.

Sleep Time

The time, in minutes, between rechecking the condition.

Numeric, 3 positions; required.

Re-alert After

The time, in minutes, for re-alerting for the condition.

Note: The re-alert after minutes should be equal to or greater than the sleep time minutes.

Numeric, 3 positions; required if Action Type is Email.

Action Type

Defines the type of action to take when the job meets the rule’s conditions.

Valid values:

Email: Send an email to the specified To Email.

Periodic Process: Run the specified periodic process. Note: When the Action Type is Periodic Process, define a From Email, Subject, To Email, and Email Text to have the system send an email alert if the condition for the job monitor rule still exists after running the periodic function. The system will continue to send an email alert until the condition is no longer met or the end time is met.

Alphanumeric, required.

Periodic Process

The code for the periodic process to run.

Periodic processes are defined in and validated against the Periodic Process table.

Alphanumeric, 10 positions; required if Action Type is Periodic Process.

Process Company

The code for the company to run the periodic process.

Company codes are defined in and validated against the Company table.

Numeric, 3 positions; optional.

From Email

The “from” email address for the job monitor rule email. See Email Address Validation.

Alphanumeric, 50 positions; required if Action Type is Email.

Subject

The subject of the job monitor rule email.

Alphanumeric, 50 positions; required if Action Type is Email.

To Email

The list of email addresses that receive the job monitor rule email. Each email address entered must be separated by a semi-colon (;).

For example: email1@add.com;email2@add.com. See Email Address Validation.

Alphanumeric, 200 positions; required if Action Type is Email.

Email Text

The text to display in the body of the job monitor rule email.

Alphanumeric, 255 positions; required if Action Type is Email.

WJMO OMSCS 19.0 December 2019 OHC