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>
136 lines
12 KiB
HTML
136 lines
12 KiB
HTML
<a name="EN-US_TOPIC_0000001764650308"></a><a name="EN-US_TOPIC_0000001764650308"></a>
|
|
|
|
<h1 class="topictitle1">PG_JOBS</h1>
|
|
<div id="body1494377960801"><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p57693551526"><strong id="EN-US_TOPIC_0000001764650308__b842352706142758">PG_JOBS</strong> records detailed information about jobs created by users. Dedicated threads poll the <strong id="EN-US_TOPIC_0000001764650308__b1565810410372">pg_jobs</strong> table and trigger jobs based on scheduled job execution time. This table belongs to the Shared Relation category. All job records are visible to all databases.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764650308__tba595b33ee9b4546985287bf6e537e83" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_JOBS columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764650308__re5a8fe3a8f124f789a4f29e569145cf0"><th align="left" class="cellrowborder" valign="top" width="26.090000000000003%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p179601085518">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="23.11%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p15960185511">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="50.8%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p3960085517">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764650308__r09e2cf73bf3a4827967e08d9c7585854"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__a72bcc3d211944104a33714d1c879f431">job_id</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__a860161a03d30489ba3e827fbf16aea99">Integer</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p165310431514">Job ID, primary key, unique (with a unique index)</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row1719246152918"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p181921965299">what</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p1219220642912">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p71923617290">Job content</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r389186f4a1a7463cbeb50bf61b4e2c84"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p196532437518">log_user</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p86538435512">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a846141fe6a7a42af88e7a78e31ee8c1b">Username of the job creator</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r9b0d786bd0fe4a95a7526a8bdb6e135f"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p146539431511">priv_user</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__a338282adc06f44b4946913e24f6437a7">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p465434345113">User ID of the job executor</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r25b3a71504a94c97b920ea21b24947f8"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__ab28488de3c364b9697cda1c99f3dc917">job_db</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__ac477d24cd9df4a9a9a9720021c8cf4b1">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a0c1d2bc32bcf4d1e81ab0d36184713b5">OID of the database where the job is executed</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row1739551215334"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p7396101211333">job_nsp</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p539601223314">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p3396171216332">OID of the namespace where a job is running</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r2b2c5c705cd541df85de63adeecb8c98"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__a1ce8ed495998433b8707b9aa6bbea87e">job_node</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__aa6946c8c42004e909c47639c7c8d2c7d">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p765414436513">CN node on which the job will be created and executed</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row1751403923413"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p051513953419">is_broken</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p1551518398344">Boolean</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p175156395348">Whether the current job is invalid</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__rbc24edf6eb774b3fad531bc5e17a8751"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p16546436511">start_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__a401f38f16c9a49379bbfe00fe38dcd0e">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a9ce820a10092416f93458edb2839c4d7">Start time of the first job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row19126045142754"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p37916678142754">next_run_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p51352095142754">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p65879000142754">Scheduled time of the next job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row54964865142849"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p6166319142857">failure_count</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p29709868142857">Smallint</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p57689097142857">Number of consecutive failures</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__row59836133142853"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__p45203044142857">interval</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__p37567913142857">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__p23102090142857">Job execution interval</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__rff65d1ea67094801828787a322f9304a"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p166562434518">last_start_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__af60ff188476a4a1c83678a4bb5da3e00">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a11e2e02977114a4f8eb9f62d019342fc">Start time of the last job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r569bc4c20b96467db29c69a04d9085f1"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__a37c1fcf1b86d461882550bbb0a3824d5">last_end_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__a9366f08fec234b9497d3c8d6d7d6a2a2">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p565674315513">End time of the last job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__r29bbad27202f4590ba57b41ad51e6de0"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__en-us_topic_0059777589_p26561438510">last_suc_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__aaea2e70c595a41efa8373f8ad55e758c">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a30d1608c4d904d59a89d1604f2e87bda">Start time of the last successful job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764650308__rf73e0595707648919882604e64c6626a"><td class="cellrowborder" valign="top" width="26.090000000000003%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001764650308__a38888bd960fe41159e56af6fc78f55fe">this_run_date</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.11%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001764650308__a8c8bfa946a274d92b8e1e4a26aa58f92">Timestamp without time zone</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="50.8%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001764650308__a78e907baf53a42f4a21c2794236bb134">Start time of the ongoing job execution, accurate to millisecond</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0561.html">System Catalogs</a></div>
|
|
</div>
|
|
</div>
|
|
|