forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
146 lines
13 KiB
HTML
146 lines
13 KiB
HTML
<a name="EN-US_TOPIC_0000001811491353"></a><a name="EN-US_TOPIC_0000001811491353"></a>
|
|
|
|
<h1 class="topictitle1">PG_JOB_SINGLE</h1>
|
|
<div id="body1599815907173"><p id="EN-US_TOPIC_0000001811491353__p65865272020">PG_JOB_SINGLE displays job information about the current node.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811491353__tbd262debac2740f5af21067785f80b31" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_JOB_SINGLE columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811491353__en-us_topic_0059778581_row5106215531"><th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001811491353__a98f0be1da5ea4e999b2ce71b34c06bb0"><strong id="EN-US_TOPIC_0000001811491353__b1720326884103812">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="20%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001811491353__afd7ef571161748c59d7eaa52b2f8a787">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="60%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001811491353__en-us_topic_0059778581_p910651155317">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001811491353__r70939aaf95e34af0ba654c84af19c37b"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p48793336208">job_id</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p1687803312012">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p2876103362012">Job ID</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__rd5d4faad338b4e5ea8548209b5f6cdc0"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p1887517332207">current_postgres_pid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p19873163352016">Bigint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p5851173319204">If the current job has been executed, the PostgreSQL thread ID of this job is recorded. The default value is <strong id="EN-US_TOPIC_0000001811491353__b94013115610">-1</strong>, indicating that the task is not executed or has been executed.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row867424225114"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p96749426511">log_user</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p116741142105119">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p36741842125110">User name of the job creator</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row1034611462511"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p13471546125120">priv_user</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p12347146145114">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p534794665112">User name of the job executor</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row877584813512"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p27751448175115">dbname</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p977594814511">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p2775204895114">Name of the database where the job is executed</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row12186351195117"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p018618511517">node_name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p518615510515">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p17187125111511">CN node on which the job will be created and executed</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row15386195305115"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p4386105315110">job_status</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p20386115313512">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p438616538519">Status of the current job. The value range is <strong id="EN-US_TOPIC_0000001811491353__b191721331163">r</strong>, <strong id="EN-US_TOPIC_0000001811491353__b41721333969">s</strong>, <strong id="EN-US_TOPIC_0000001811491353__b141731833067">f</strong>, <strong id="EN-US_TOPIC_0000001811491353__b20174173318611">d</strong>, <strong id="EN-US_TOPIC_0000001811491353__b117413331067">p</strong>, <strong id="EN-US_TOPIC_0000001811491353__b21758338614">w</strong>, or <strong id="EN-US_TOPIC_0000001811491353__b1017673315614">l</strong>. The default value is <strong id="EN-US_TOPIC_0000001811491353__b717619333612">s</strong>. The indications are as follows:</p>
|
|
<ul id="EN-US_TOPIC_0000001811491353__ul39973288289"><li id="EN-US_TOPIC_0000001811491353__li4997132813286">r=running</li><li id="EN-US_TOPIC_0000001811491353__li1499782852817">s=successfully finished</li><li id="EN-US_TOPIC_0000001811491353__li1099772819286">f=job failed</li><li id="EN-US_TOPIC_0000001811491353__li8998162815285">d=disable</li><li id="EN-US_TOPIC_0000001811491353__li13861141215255">p=pending</li><li id="EN-US_TOPIC_0000001811491353__li7921154259">w=waiting</li><li id="EN-US_TOPIC_0000001811491353__li1341910552519">l=launching</li></ul>
|
|
<div class="note" id="EN-US_TOPIC_0000001811491353__note81622539192"><span class="notetitle"> NOTE: </span><div class="notebody"><ul id="EN-US_TOPIC_0000001811491353__ul4961338132213"><li id="EN-US_TOPIC_0000001811491353__li174081043132214">Note: When you disable a scheduled task (by setting <strong id="EN-US_TOPIC_0000001811491353__b157026173304">job_queue_processes</strong> to <strong id="EN-US_TOPIC_0000001811491353__b11357161813168">0</strong>), the thread monitor the job execution is not started, and the <strong id="EN-US_TOPIC_0000001811491353__b9357131810167">job_status</strong> will not be updated. You can ignore the <strong id="EN-US_TOPIC_0000001811491353__b113571188160">job_status</strong>.</li><li id="EN-US_TOPIC_0000001811491353__li79611038132215">Only when the scheduled task function is enabled (that is, when <strong id="EN-US_TOPIC_0000001811491353__b586252081619">job_queue_processes</strong> is not <strong id="EN-US_TOPIC_0000001811491353__b128621720181611">0</strong>), the system updates the value of <strong id="EN-US_TOPIC_0000001811491353__b10862202041619">job_status</strong> based on the real-time job status.</li></ul>
|
|
</div></div>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row15623155519515"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p0623165513518">start_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p12623135512511">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p962311557510">Start time of the first job execution, precise to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row183019574516"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p198301257125111">next_run_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p198301257125117">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p18830155710518">Scheduled time of the next job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row17981205914518"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p199811559135119">failure_count</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p19811359115115">Smallint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p16981259195119">Number of consecutive failures.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row196688235216"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p12668122115211">interval</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p116681527527">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p1668228523">Job execution interval</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row66813712521"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p76807105211">last_start_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p16897155217">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p96814765215">Start time of the last job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row93756975215"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p33755917521">last_end_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p6375169195213">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p1737518975213">End time of the last job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row576417118527"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p97641112522">last_suc_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p276410118524">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p376481175220">Start time of the last successful job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row161158301564"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p1611683013565">this_run_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p14116173095619">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p21161030165615">Start time of the ongoing job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row1036194611457"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p123654616453">nspname</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p3361546154515">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p83664604511">Name of the namespace where a job is running</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811491353__row1222074944516"><td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811491353__p19220154917453">what</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="20%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811491353__p42209496454">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="60%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811491353__p18220549134511">Job content</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0639.html">System Views</a></div>
|
|
</div>
|
|
</div>
|
|
|