codekingpro/portable-devtools
114k
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6 <head>
7 <meta charset="utf-8" />
8 <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10 <title>DBMS Job — pgAdmin 4 8.6 documentation</title>
11 <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12 <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13
14 <script src="_static/documentation_options.js?v=d4c83366"></script>
15 <script src="_static/doctools.js?v=9a2dae69"></script>
16 <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17
18 <script src="_static/sidebar.js"></script>
19
20 <link rel="index" title="Index" href="genindex.html" />
21 <link rel="search" title="Search" href="search.html" />
22 <link rel="next" title="DBMS Program" href="dbms_program.html" />
23 <link rel="prev" title="Using EDB Job Scheduler" href="dbms_job_scheduler.html" />
24 </head><body>
25 <div class="related" role="navigation" aria-label="related navigation">
26 <h3>Navigation</h3>
27 <ul>
28 <li class="right" style="margin-right: 10px">
29 <a href="genindex.html" title="General Index"
30 accesskey="I">index</a></li>
31 <li class="right" >
32 <a href="dbms_program.html" title="DBMS Program"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="dbms_job_scheduler.html" title="Using EDB Job Scheduler"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="managing_database_objects.html" >Managing Database Objects</a> »</li>
39 <li class="nav-item nav-item-2"><a href="dbms_job_scheduler.html" accesskey="U">Using EDB Job Scheduler</a> »</li>
40 <li class="nav-item nav-item-this"><a href="">DBMS Job</a></li>
41 </ul>
42 </div>
43
44 <div class="document">
45 <div class="documentwrapper">
46 <div class="bodywrapper">
47 <div class="body" role="main">
48
49 <section id="dbms-job">
50<span id="id1"></span><h1><span class="target" id="index-0"></span>DBMS Job<a class="headerlink" href="#dbms-job" title="Link to this heading">¶</a></h1>
51<p>Use the <em>DBMS Job</em> dialog to create a DBMS Job.</p>
52<img alt="DBMS Job dialog general tab" class="align-center" src="_images/dbms_job_general.png" />
53<p>Use the fields in the <em>General</em> tab to create job:</p>
54<ul class="simple">
55<li><p>Use the <em>Name</em> field to add a descriptive name for the job. The name will
56be displayed in the <em>pgAdmin</em> object explorer.</p></li>
57<li><p>Use the <em>Enabled?</em> switch to indicate that job should be enabled or disabled.</p></li>
58<li><p>Use the <em>Job Type</em> field to select the type of the job. Type could be SELF-CONTAINED or PRE-DEFINED.
59If the Job Type is Self-Contained you need to specify the action and repeat interval in the Action and Repeat tabs respectively.
60If the Job Type is Pre-Defined you need to specify the existing Program and Schedule names in the Pre-Defined tab.</p></li>
61<li><p>Store notes about the job in the <em>Comment</em> field.</p></li>
62</ul>
63<p>Click the <em>Action</em> tab to continue.</p>
64<img alt="DBMS Job dialog action tab" class="align-center" src="_images/dbms_job_action.png" />
65<p>Use the <em>Action</em> tab to select the action for the job. This tab is only enabled when the job type is ‘SELF-CONTAINED’.</p>
66<ul class="simple">
67<li><p>Use the <em>Type</em> field to select the type of the job. Type could be PLSQL BLOCK or STORED PROCEDURE.</p></li>
68<li><p>Use the <em>Procedure</em> field to select an existing procedure that executes when the job is invoked.</p></li>
69<li><p><em>Number of Arguments</em> field is read-only and indicates the quantity of arguments necessary for the chosen procedure.</p></li>
70</ul>
71<p>Click the <em>Code</em> tab to continue.</p>
72<img alt="DBMS Job dialog code tab" class="align-center" src="_images/dbms_job_code.png" />
73<ul class="simple">
74<li><p>Use the <em>Code</em> field to write the code that executes when the job is invoked.
75This tab is only enabled when the job type is ‘SELF-CONTAINED’ and type of the action is set to ‘PLSQL BLOCK’.</p></li>
76</ul>
77<p>Click the <em>Arguments</em> tab to continue.</p>
78<img alt="DBMS Job dialog arguments tab" class="align-center" src="_images/dbms_job_arguments.png" />
79<ul class="simple">
80<li><p><em>Arguments</em> tab outlines the arguments required by the selected procedure in the ‘Action’ tab. This tab is only enabled when the job type is ‘SELF-CONTAINED’.</p></li>
81</ul>
82<p>Click the <em>Repeat</em> tab to continue.</p>
83<img alt="DBMS Job dialog repeat tab" class="align-center" src="_images/dbms_job_repeat.png" />
84<p>Use the <em>Repeat</em> tab to select the repeat interval for the job. This tab is only enabled when the job type is ‘SELF-CONTAINED’.</p>
85<ul class="simple">
86<li><p>Use the calendar selector in the <em>Start</em> field to specify the starting date
87and time for the job.</p></li>
88<li><p>Use the calendar selector in the <em>End</em> field to specify the ending date and
89time for the job.</p></li>
90<li><p>Use the <em>Frequency</em> field to select the frequency. Frequency is one of the following:
91YEARLY, MONTHLY, WEEKLY, DAILY, HOURLY, MINUTELY.</p></li>
92<li><p>Use the <em>Date</em> field to select the date on which job will execute.Date is YYYYMMDD.</p></li>
93<li><p>Use the <em>Months</em> field to select the months in which the job will execute.</p></li>
94<li><p>Use the <em>Week Days</em> field to select the days on which the job will execute.</p></li>
95<li><p>Use the <em>Month Days</em> field to select the numeric days on which the job will
96execute.</p></li>
97<li><p>Use the <em>Hours</em> field to select the hour at which the job will execute.</p></li>
98<li><p>Use the <em>Minutes</em> field to select the minute at which the job will execute.</p></li>
99</ul>
100<p>Click the <em>Pre-Defined</em> tab to continue.</p>
101<img alt="DBMS Job dialog predefined tab" class="align-center" src="_images/dbms_job_predefined.png" />
102<p>Use the <em>Pre-Defined</em> tab to select the existing program and schedule to create the job.
103This tab is only enabled when the job type is ‘PRE-DEFINED’.</p>
104<ul class="simple">
105<li><p>Use the <em>Program Name</em> field to select the existing program.</p></li>
106<li><p>Use the <em>Schedule Name</em> field to select an existing schedule.</p></li>
107</ul>
108<p>Click the <em>SQL</em> tab to continue.</p>
109<p>Your entries in the <em>DBMS Job</em> dialog generate a SQL command (see an example below).
110Use the <em>SQL</em> tab for review; revisit or switch tabs to make any changes to the
111SQL command.</p>
112<p><strong>Example</strong></p>
113<p>The following is an example of the sql command generated by user selections in
114the <em>DBMS Job</em> dialog:</p>
115<img alt="DBMS Job dialog sql tab" class="align-center" src="_images/dbms_job_sql.png" />
116<ul class="simple">
117<li><p>Click the <em>Info</em> button (i) to access online help.</p></li>
118<li><p>Click the <em>Help</em> button (?) to access dialog help.</p></li>
119<li><p>Click the <em>Save</em> button to save work.</p></li>
120<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
121<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
122</ul>
123</section>
124
125
126 <div class="clearer"></div>
127 </div>
128 </div>
129 </div>
130 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
131 <div class="sphinxsidebarwrapper">
132<h3><a href="index.html">Table of Contents</a></h3>
133<ul class="current">
134<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
135<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
136<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
137<li class="toctree-l1"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a></li>
138<li class="toctree-l1 current"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a><ul class="current">
139<li class="toctree-l2"><a class="reference internal" href="cast_dialog.html">Cast Dialog</a></li>
140<li class="toctree-l2 current"><a class="reference internal" href="dbms_job_scheduler.html">Using EDB Job Scheduler</a></li>
141<li class="toctree-l2"><a class="reference internal" href="collation_dialog.html">Collation Dialog</a></li>
142<li class="toctree-l2"><a class="reference internal" href="domain_dialog.html">Domain Dialog</a></li>
143<li class="toctree-l2"><a class="reference internal" href="domain_constraint_dialog.html">Domain Constraints Dialog</a></li>
144<li class="toctree-l2"><a class="reference internal" href="event_trigger_dialog.html">Event Trigger Dialog</a></li>
145<li class="toctree-l2"><a class="reference internal" href="extension_dialog.html">Extension Dialog</a></li>
146<li class="toctree-l2"><a class="reference internal" href="foreign_data_wrapper_dialog.html">Foreign Data Wrapper Dialog</a></li>
147<li class="toctree-l2"><a class="reference internal" href="foreign_server_dialog.html">Foreign Server Dialog</a></li>
148<li class="toctree-l2"><a class="reference internal" href="foreign_table_dialog.html">Foreign Table Dialog</a></li>
149<li class="toctree-l2"><a class="reference internal" href="fts_configuration_dialog.html">FTS Configuration Dialog</a></li>
150<li class="toctree-l2"><a class="reference internal" href="fts_dictionary_dialog.html">FTS Dictionary Dialog</a></li>
151<li class="toctree-l2"><a class="reference internal" href="fts_parser_dialog.html">FTS Parser Dialog</a></li>
152<li class="toctree-l2"><a class="reference internal" href="fts_template_dialog.html">FTS Template Dialog</a></li>
153<li class="toctree-l2"><a class="reference internal" href="function_dialog.html">Function Dialog</a></li>
154<li class="toctree-l2"><a class="reference internal" href="language_dialog.html">Language Dialog</a></li>
155<li class="toctree-l2"><a class="reference internal" href="materialized_view_dialog.html">Materialized View Dialog</a></li>
156<li class="toctree-l2"><a class="reference internal" href="package_dialog.html">Package Dialog</a></li>
157<li class="toctree-l2"><a class="reference internal" href="procedure_dialog.html">Procedure Dialog</a></li>
158<li class="toctree-l2"><a class="reference internal" href="publication_dialog.html">Publication Dialog</a></li>
159<li class="toctree-l2"><a class="reference internal" href="schema_dialog.html">Schema Dialog</a></li>
160<li class="toctree-l2"><a class="reference internal" href="sequence_dialog.html">Sequence Dialog</a></li>
161<li class="toctree-l2"><a class="reference internal" href="subscription_dialog.html">Subscription Dialog</a></li>
162<li class="toctree-l2"><a class="reference internal" href="synonym_dialog.html">Synonym Dialog</a></li>
163<li class="toctree-l2"><a class="reference internal" href="trigger_function_dialog.html">Trigger Function Dialog</a></li>
164<li class="toctree-l2"><a class="reference internal" href="type_dialog.html">Type Dialog</a></li>
165<li class="toctree-l2"><a class="reference internal" href="user_mapping_dialog.html">User Mapping Dialog</a></li>
166<li class="toctree-l2"><a class="reference internal" href="view_dialog.html">View Dialog</a></li>
167</ul>
168</li>
169<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
170<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
171<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
172<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
173<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
174<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
175<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
176<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
177<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
178</ul>
179
180<search id="searchbox" style="display: none" role="search">
181 <h3 id="searchlabel">Quick search</h3>
182 <div class="searchformwrapper">
183 <form class="search" action="search.html" method="get">
184 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
185 <input type="submit" value="Go" />
186 </form>
187 </div>
188</search>
189<script>document.getElementById('searchbox').style.display = "block"</script>
190 </div>
191<div id="sidebarbutton" title="Collapse sidebar">
192<span>«</span>
193</div>
194
195 </div>
196 <div class="clearer"></div>
197 </div>
198 <div class="related" role="navigation" aria-label="related navigation">
199 <h3>Navigation</h3>
200 <ul>
201 <li class="right" style="margin-right: 10px">
202 <a href="genindex.html" title="General Index"
203 >index</a></li>
204 <li class="right" >
205 <a href="dbms_program.html" title="DBMS Program"
206 >next</a> |</li>
207 <li class="right" >
208 <a href="dbms_job_scheduler.html" title="Using EDB Job Scheduler"
209 >previous</a> |</li>
210 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
211 <li class="nav-item nav-item-1"><a href="managing_database_objects.html" >Managing Database Objects</a> »</li>
212 <li class="nav-item nav-item-2"><a href="dbms_job_scheduler.html" >Using EDB Job Scheduler</a> »</li>
213 <li class="nav-item nav-item-this"><a href="">DBMS Job</a></li>
214 </ul>
215 </div>
216 <div class="footer" role="contentinfo">
217 <div class="related" role="navigation" aria-label="related navigation">
218 <ul>
219 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
220 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
221 <li class="right" ><a href="dbms_program.html" title="DBMS Program" accesskey="N">next</a> |</li>
222 <li class="right" ><a href="dbms_job_scheduler.html" title="Using EDB Job Scheduler" accesskey="P">previous</a> |</li>
223 </ul>
224 </div>
225 </div>
226 </body>
227</html>