Job Executions

The Job Executions (md_job_execution) view allows you to query the records in the job executions table. A job execution record is created when a timer configured as a job is fired. All the corresponding messages reference that job execution record.

  • This view enables an administrator to keep track of errors related to a particular job. It also enables an administrator to track the number of messages queued for a given job.

  • Job monitoring is greatly simplified by virtue of the messages having a common job execution identifier.

Note: If a staging record belonging to a job is put on hold, it will have the effect of quarantining the message, therefore removing it from the job. Furthermore, the staging record cannot be added back to the job.

The following list defines every field available in the job execution (md_job_execution) resource in alphabetical order:

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Database Name - this field is not maintainable. The name of the database associated with the job execution record.

  • End Time - this field is not maintainable. The time the job execution was completed.

  • Errors - this field is not maintainable. An expression column that displays the number of errors, when applicable.

  • Has Error - this field is not maintainable. A flag that indicates whether or not errors occurred during the job execution.

  • Instance Name - this field is not maintainable. The unique identifier for a given application server instance.

    • A concatenation of the host name and environment name to be specified.

    • Example: lxtrn.somecompany.org_pr_100_i

  • Job Description - this field is not maintainable. A user-defined job description.

  • Job Execution ID - this field is not maintainable. The job execution identifier.

  • Job Execution Status - this field is not maintainable. The job execution status. The following options are available:

    • Created - indicates that the job execution record has been created.

    • Running - indicates that the thread is executing.

    • Stopped - indicates that the job execution has been stopped. A start time is displayed, but not an end time.

    • Failed - indicates that the job execution failed.

    • Completed - indicates that the job execution is complete and an end time is displayed.

  • Messages - this field is not maintainable. Click the hyperlink associated with a given service to open the queue message view for the indicated database.

  • Modification Counter - this field is not maintainable. The date and time a given record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

  • Number of Queue Messages - this field is not maintainable. The current queue message count.

  • Start Time - this field is not maintainable. The job execution start time.

  • Table Name - this field is not maintainable. The name of the table associated with the job.

  • Timer Name - this field is not maintainable. The name of the timer associated with the job.

For the functionality of each action (i.e. button) available on this view, refer to the About the Actions topic.