{"id":1027,"date":"2020-07-13T11:03:34","date_gmt":"2020-07-13T14:03:34","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=1027"},"modified":"2021-03-19T12:06:23","modified_gmt":"2021-03-19T15:06:23","slug":"listando-conteudo-job","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2020\/07\/13\/listando-conteudo-job\/","title":{"rendered":"Listando conte\u00fado Job"},"content":{"rendered":"<h2 id=\"toc_0\">Query<\/h2>\n<pre class=\"lang:plsql decode:true \">select owner as schema_name,\n       job_name,\n       job_style,\n       case when job_type is null \n                 then 'PROGRAM'\n            else job_type end as job_type,  \n       case when job_type is null\n                 then program_name\n                 else job_action end as job_action,\n       start_date,\n       case when repeat_interval is null\n            then schedule_name\n            else repeat_interval end as schedule,\n       last_start_date,\n       next_run_date,\n       state\nfrom sys.all_scheduler_jobs\norder by owner,\n         job_name;<\/pre>\n<p>&nbsp;<\/p>\n<h2 id=\"toc_1\">Columns<\/h2>\n<ul>\n<li><strong>schema_name<\/strong> &#8211; name of the schema<\/li>\n<li><strong>job_name<\/strong> &#8211; name of the job<\/li>\n<li><strong>job_style<\/strong>:\n<ul>\n<li>REGULAR<\/li>\n<li>LIGHTWEIGHT<\/li>\n<\/ul>\n<\/li>\n<li><strong>job_type<\/strong> &#8211; inline job action type\n<ul>\n<li>PLSQL_BLOCK<\/li>\n<li>STORED_PROCEDURE<\/li>\n<li>EXECUTABLE<\/li>\n<li>CHAIN<\/li>\n<li>SQL_SCRIPT<\/li>\n<li>BACKUP_SCRIPT<\/li>\n<li>EXTERNAL_SCRIPT<\/li>\n<li>PROGRAM<\/li>\n<\/ul>\n<\/li>\n<li><strong>job_action<\/strong> &#8211; PL\/SQL code or program\/routine name to call<\/li>\n<li><strong>start_date<\/strong> &#8211; when job will be launched first time<\/li>\n<li><strong>schedule<\/strong> &#8211; inline schedule PL\/SQL expression, calendar string or name of the schedule<\/li>\n<li><strong>last_start_date<\/strong> &#8211; last date on which the job started running<\/li>\n<li><strong>next_run_date<\/strong>: next date on which the job is scheduled to run<\/li>\n<li><strong>state<\/strong>:\n<ul>\n<li>Disabled<\/li>\n<li>Scheduled<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2 id=\"toc_2\">Rows<\/h2>\n<ul>\n<li><strong>One row:<\/strong> represents one job<\/li>\n<li><strong>Scope of rows:<\/strong> all jobs in database<\/li>\n<li><strong>Ordered by<\/strong> job schema, job name<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Query select owner as schema_name, job_name, job_style, case when job_type is null then &#8216;PROGRAM&#8217; else job_type end as job_type, case when job_type is null then program_name else job_action end as job_action, start_date, case when repeat_interval is null then schedule_name else repeat_interval end as schedule, last_start_date, next_run_date, state from sys.all_scheduler_jobs order by owner, job_name; &nbsp; Columns&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1027","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1027","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=1027"}],"version-history":[{"count":2,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1027\/revisions"}],"predecessor-version":[{"id":1045,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/1027\/revisions\/1045"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=1027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=1027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=1027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}