REMOTE_JOB_REQUESTS_V

This view shows the details of the request to bind to a job on a remote engine. The bind request is sent to the remote engine where the job instance resides. Every bind request contains the information to identify the job's instance in the remote engine plan.
Table 1. The REMOTE_JOB_REQUESTS_V view
Column name Description Type Length
Remote_job_identifier The identifier of the shadow job in the remote engine. varchar 1000
Remote_job_start_time The time used to identify the remote job instance in the local plan. timestamp 10
Interval_start_offset The relative or absolute offset to define the start of the interval where to look for remote predecessor job instance in the local plan. This column is filled in when a relative or absolute interval based matching criteria is specified in the shadow job definition. decimal 10
Interval_end_offset The relative or absolute offset to define the end of the interval where to look for remote predecessor job instance in the local plan. This column is filled in when a relative or absolute interval based matching criteria is specified in the shadow job definition. decimal 10
Local_workstation_name The name of the job stream workstation to match in the local plan. It is referenced in the shadow job definition on the remote engine. varchar 1000
Local_job_stream_name The name of the job stream to match in the local engine plan. It is referenced in the shadow job definition on the remote engine. varchar 1000
Local_job_name The name of the job to match in the local plan. It is referenced in the shadow job definition on the remote engine. varchar 1000
Local_job_start_time The time of the job stream instance matched in the local plan. timestamp 10
Matching_criteria The matching criteria used to find the required job stream instance to match in the local plan. These are the possible values for this field:
B
Closest preceding
D
On the same day
A
Within an absolute interval
R
Within a relative interval
character 1
Request_status The result of the bind request. The request status says whether an existing job instance in the local engine plan matched or not the remote job information specified in the shadow job definition. These are the possible values for this field:
0
The subscription has been received.
1
The subscription is waiting for the bind in the Long Term Plan (LTP).
2
The subscription has been bound in the Long Term Plan.
3
The subscription is waiting for the bind in the Current Plan (CP).
4
The subscription has been bound in the Current Plan.
5
The bind in Long Term Plan failed.
6
The bind in Current Plan failed.
decimal 2
Notification_URI The URI where to send back the notification about the remote job status. It is the URI identifying the remote engine where the shadow job is defined. varchar 1024