yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
sgode-patch-2
doc-exports/docs/dws/dev/dws_04_0041.html
luhuayi 177cd61a57 DWS DEVG 910.211 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>
2025-05-05 07:44:03 +00:00

171 lines
30 KiB
HTML
Raw Permalink Blame History

<a name="EN-US_TOPIC_0000001811491105"></a><a name="EN-US_TOPIC_0000001811491105"></a>
<h1 class="topictitle1">Creating and Managing GaussDB(DWS) Scheduled Tasks</h1>
<div id="body8662426"><p id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_a9ea75771745f4fc8aa59fe57ebc70b47">GaussDB(DWS) allows users to create scheduled tasks, which are automatically executed at specified time points, reducing O&amp;M workload.</p>
<p id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_a53281b045f304a608e5bc95a7073816d">The database follows Oracle's scheduled task feature, allowing you to use the DBMS.JOB advanced package interfaces to create, run, delete, and modify scheduled tasks (including the task ID, task enabling and disabling, task triggering time, triggering interval, and task content).</p>
<div class="note" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_note7269732153916"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><ul id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_ul575163717417"><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_li4751437184111">The hybrid data warehouse (standalone) does not support scheduled tasks.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_li1220834164116">The execution statements of scheduled tasks are not recorded in the <a href="dws_04_0397.html">Real-time Top SQL</a> logs. The statements can be recorded only in versions later than 8.2.1.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_li8818279612">By default, GaussDB(DWS) uses the UTC time. The execution time of the scheduled task needs to be converted to the time zone of the user.</li></ul>
</div></div>
<div class="section" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s69827ffee4d646608d4ff259b3541297"><h4 class="sectiontitle">Periodic Task Management</h4><ol id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_oef75d53208a64186aca235fb3981983a"><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l8131a771bb1f454caf55b0b56c3e1b8a"><span>Creates a test table.</span><p><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s4e899745546e400bb3b68d8456d9322b"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span><span class="w"> </span><span class="n">test</span><span class="p">(</span><span class="n">id</span><span class="w"> </span><span class="nb">int</span><span class="p">,</span><span class="w"> </span><span class="k">time</span><span class="w"> </span><span class="nb">date</span><span class="p">);</span>
</pre></div></td></tr></table></div>
</div>
<p id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_p4629125315152">If the following information is displayed, the table has been created.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_screen07941951172311"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">TABLE</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l82aafaf11f244f50b679e0eb3cd191ac"><span>Create the customized storage procedure.</span><p><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_sf7c3dd0b06c54627adc80a54d5224526"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span>
<span class="normal">6</span>
<span class="normal">7</span>
<span class="normal">8</span>
<span class="normal">9</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">OR</span><span class="w"> </span><span class="k">REPLACE</span><span class="w"> </span><span class="k">PROCEDURE</span><span class="w"> </span><span class="n">PRC_JOB_1</span><span class="p">()</span>
<span class="k">AS</span>
<span class="n">N_NUM</span><span class="w"> </span><span class="nb">integer</span><span class="w"> </span><span class="p">:</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span>
<span class="k">BEGIN</span>
<span class="k">FOR</span><span class="w"> </span><span class="n">I</span><span class="w"> </span><span class="k">IN</span><span class="w"> </span><span class="mi">1</span><span class="p">..</span><span class="mi">1000</span><span class="w"> </span><span class="n">LOOP</span>
<span class="k">INSERT</span><span class="w"> </span><span class="k">INTO</span><span class="w"> </span><span class="n">test</span><span class="w"> </span><span class="k">VALUES</span><span class="p">(</span><span class="n">I</span><span class="p">,</span><span class="n">SYSDATE</span><span class="p">);</span>
<span class="k">END</span><span class="w"> </span><span class="n">LOOP</span><span class="p">;</span>
<span class="k">END</span><span class="p">;</span>
<span class="o">/</span>
</pre></div></td></tr></table></div>
</div>
<p id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_p56351017132613">If the following information is displayed, the procedure has been created.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_screen940372616346"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">PROCEDURE</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l837da2ebc4054cac893a39830635c0c4"><span>Create a task.</span><p><ul id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_uda90efa65f094e5db7e1f5621ac972dc"><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_lbc853f20eb2e4fdca2815ac67246f282">Create a task with unspecified <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b845174010165">job_id</strong> and execute the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b348240101614">PRC_JOB_1</strong> storage procedure every two minutes.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_sc80ce3aaaae9465f958b2eb352075e75"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">submit</span><span class="p">(</span><span class="s1">'call public.prc_job_1(); '</span><span class="p">,</span><span class="w"> </span><span class="n">sysdate</span><span class="p">,</span><span class="w"> </span><span class="s1">'interval ''1 minute'''</span><span class="p">,</span><span class="w"> </span><span class="p">:</span><span class="n">a</span><span class="p">);</span>
<span class="n">job</span>
<span class="c1">-----</span>
<span class="mi">1</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l147492232e14446da45ef827f089ace2">Create task with specified job_id.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_sb2ccbf0d5b4542dd9bf580210d2b4778"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">isubmit</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="s1">'call public.prc_job_1(); '</span><span class="p">,</span><span class="w"> </span><span class="n">sysdate</span><span class="p">,</span><span class="w"> </span><span class="s1">'interval ''1 minute'''</span><span class="p">);</span>
<span class="n">isubmit</span>
<span class="c1">---------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li></ul>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l76fa9d576b0640179c4eea44845fae97"><span>View the created task information about the current user in the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b873511131057">USER_JOBS</strong> view.</span><p><p id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_p1834384213191">Only the system administrator can access this system view. For details about the fields, see <a href="dws_04_0866.html#EN-US_TOPIC_0000001811609909__tfc79ceaea73a45b685f452da34d39554">Table 1</a>.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s89630c060818448ca5398aa1b761ae1b"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal"> 1</span>
<span class="normal"> 2</span>
<span class="normal"> 3</span>
<span class="normal"> 4</span>
<span class="normal"> 5</span>
<span class="normal"> 6</span>
<span class="normal"> 7</span>
<span class="normal"> 8</span>
<span class="normal"> 9</span>
<span class="normal">10</span></pre></div></td><td class="code"><div><pre><span></span><span class="n">postgresselect</span><span class="w"> </span><span class="n">job</span><span class="p">,</span><span class="n">dbname</span><span class="p">,</span><span class="n">start_date</span><span class="p">,</span><span class="n">last_date</span><span class="p">,</span><span class="n">this_date</span><span class="p">,</span><span class="n">next_date</span><span class="p">,</span><span class="n">broken</span><span class="p">,</span><span class="n">status</span><span class="p">,</span><span class="nb">interval</span><span class="p">,</span><span class="n">failures</span><span class="p">,</span><span class="n">what</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">user_jobs</span><span class="p">;</span>
<span class="w"> </span><span class="n">job</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">dbname</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">start_date</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">last_date</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">this_date</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">next_date</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">broken</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">status</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">failures</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">what</span>
<span class="c1">-----+----------+----------------------------+----------------------------+----------------------------+---------------------+--------+--------+---------------------+----------+----------------</span>
<span class="c1">-----------</span>
<span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">db_demo</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">01</span><span class="p">.</span><span class="mi">829436</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">03</span><span class="p">.</span><span class="mi">174817</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">01</span><span class="p">.</span><span class="mi">829436</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">59</span><span class="p">:</span><span class="mi">01</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">n</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">s</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="s1">'1 minute'</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">call</span><span class="w"> </span><span class="k">public</span><span class="p">.</span><span class="n">prc</span>
<span class="n">_job_1</span><span class="p">();</span>
<span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">db_demo</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">15</span><span class="p">.</span><span class="mi">893383</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">16</span><span class="p">.</span><span class="mi">608959</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">58</span><span class="p">:</span><span class="mi">15</span><span class="p">.</span><span class="mi">893383</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">03</span><span class="o">-</span><span class="mi">25</span><span class="w"> </span><span class="mi">07</span><span class="p">:</span><span class="mi">59</span><span class="p">:</span><span class="mi">15</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">n</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">s</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="s1">'1 minute'</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">call</span><span class="w"> </span><span class="k">public</span><span class="p">.</span><span class="n">prc</span>
<span class="n">_job_1</span><span class="p">();</span>
<span class="p">(</span><span class="mi">2</span><span class="w"> </span><span class="k">rows</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_la63c1532f82a4745b95d9a05333b854d"><span>Stop a task.</span><p><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s4a25227134114937b4c579895d2cfbb7"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">broken</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="k">true</span><span class="p">);</span>
<span class="n">broken</span>
<span class="c1">--------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_lf80e6713bfd7478fbc0653a652974a21"><span>Start a task.</span><p><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s6ef801a5ce014db3983341c0256f9a38"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">broken</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="k">false</span><span class="p">);</span>
<span class="n">broken</span>
<span class="c1">--------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_lb4477e9a76cc4fbc87840b869c45460c"><span>Modify attributes of a task.</span><p><ul id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_u84d8c7ad6ef047189ff0543f1622f73e"><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l6cd3c32a1bac4c7583d7c77861ffc8e7">Modify the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b149217329286">Next_date</strong> parameter information about a task. For example, change the value of <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b4593641816">Next_date</strong> of Job1 to 1 hour.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s25f886401a4341ee95553c622a239914"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">next_date</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="n">sysdate</span><span class="o">+</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">/</span><span class="mi">24</span><span class="p">);</span>
<span class="n">next_date</span>
<span class="c1">-----------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l10d7020da96c44ec9fb8f96454e9e2c1">Modify the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b196909571293">Interval</strong> parameter information of a task. For example, change the value of <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b55820439814">Interval</strong> of Job1 to 1 hour.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s6aab18d6ecbe4b20b5fd23c4c1e2c732"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="nb">interval</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="s1">'sysdate + 1.0/24'</span><span class="p">);</span>
<span class="nb">interval</span>
<span class="c1">----------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l8ef21eced1c9406299981b0907e27710">Modify the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b34325233017">What</strong> parameter information of a <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b843311211302">JOB</strong>. For example, change <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b968312210915">What</strong> of <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b78061551896">Job1</strong> to <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b245916111792">insert into public.test values(333, sysdate+5)</strong>.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_sc9968a2920394c5fb55d62c8e6a0d5e7"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">what</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="s1">'insert into public.test values(333, sysdate+5);'</span><span class="p">);</span>
<span class="n">what</span>
<span class="c1">------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l51fe491f89c94af9aaffd7e1ead4a4b6">Modify <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b842352706112856">Next_date</strong>, <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b84235270611290">Interval</strong>, and <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b84235270611293">What</strong> parameter information of <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b842352706112919">JOB</strong>.<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s260369612aaf45a6b68b87b138ccac40"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">change</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="s1">'call public.prc_job_1();'</span><span class="p">,</span><span class="w"> </span><span class="n">sysdate</span><span class="p">,</span><span class="w"> </span><span class="s1">'interval ''1 minute'''</span><span class="p">);</span>
<span class="n">change</span>
<span class="c1">--------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</li></ul>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l23f44a7e0e0a4589981871b6117cd924"><span>Delete a job.</span><p><div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_s7a2b90ce28ce4895a8b5e0c2c9e1e08c"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">call</span><span class="w"> </span><span class="n">dbms_job</span><span class="p">.</span><span class="n">remove</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span>
<span class="n">remove</span>
<span class="c1">--------</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</p></li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_le1b63e8f5d9642169eca2dc0165168eb"><span>Set job permissions.</span><p><ul id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_u882d1628a3aa493aba21e9942675e9e3"><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l8b74cc61d9804c6f8ee5522791dc1868">During the creation of a job, the job is bound to the user and database that created the job. Accordingly, the user and database are added to <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b36472545265">dbname</strong> and <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b16471954122614">log_user</strong> columns in the <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b664711540260">pg_job</strong> system view, respectively.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l4745cf1bb3874e248db2348fcf3de01c">If the current user is a DBA user, system administrator, or the user who created the job (<strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b11813511192715">log_user</strong> in <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b9814161122716">pg_job</strong>), the user has the permissions to delete or modify parameter settings of the job using the remove, change, next_data, what, or interval interface. Otherwise, the system displays a message indicating that the current user has no permission to perform operations on the JOB.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l2f7987e6b0dc44c4b554f444a353dc7b">If the current database is the one that created a job, (that is, <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b4989163916330">dbname</strong> in <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b11989143911339">pg_job</strong>), you can delete or modify parameter settings of the job using the remove, change, next_data, what, or interval interface.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l1344c340986e452285ad57513b7b35cc">When deleting the database that created a job, (that is, <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b2013865053313">dbname</strong> in <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b913825023311">pg_job</strong>), the system associatively deletes the job records of the database.</li><li id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_l8157b68968e84c23ae091fec5e07ac52">When deleting the user who created a job, (that is, <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b128231254813">log_user</strong> in <strong id="EN-US_TOPIC_0000001811491105__en-us_topic_0000001233761715_b5296161214819">pg_job</strong>), the system associatively deletes the job records of the user.</li></ul>
</p></li></ol>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0016.html">Creating and Managing GaussDB(DWS) Database Objects</a></div>
</div>
</div>
View Git Blame Copy Permalink