How to add details of ALL_SCHEDULER_JOB_RUN_DETAILS in a table using stored procedures?
0
The below procedure runs a weekly job of dropping partitions from tables that is 6 months old. I would now like to add the logs of this job in a separate table using ALL_SCHEDULER_JOB_RUN_DETAILS. I'm not sure how to do this. Any help is highly appreciated.
PROCEDURE weekly_scheduled_job IS
BEGIN
dbms_scheduler.create_job(
job_name => 'delete_partitions'
,job_type => 'STORED_PROCEDURE'
,job_action => '"TEST_OWNER"."PURGE_LOG_PARTS"'
,start_date => 'SYSTIMESTAMP'
,repeat_interval => 'freq=WEEKLY; byday=sun;byhour=07;byminute=0;bysecond=0'
,end_date => NULL
,enabled => TRUE
,comments => 'runs weekly and looks for partitions that needs to be purged'
);
END;
oracle plsql scheduled-tasks
edited Jan 2 at 10:17
APC
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
add a comment |
0
The below procedure runs a weekly job of dropping partitions from tables that is 6 months old. I would now like to add the logs of this job in a separate table using ALL_SCHEDULER_JOB_RUN_DETAILS. I'm not sure how to do this. Any help is highly appreciated.
PROCEDURE weekly_scheduled_job IS
BEGIN
dbms_scheduler.create_job(
job_name => 'delete_partitions'
,job_type => 'STORED_PROCEDURE'
,job_action => '"TEST_OWNER"."PURGE_LOG_PARTS"'
,start_date => 'SYSTIMESTAMP'
,repeat_interval => 'freq=WEEKLY; byday=sun;byhour=07;byminute=0;bysecond=0'
,end_date => NULL
,enabled => TRUE
,comments => 'runs weekly and looks for partitions that needs to be purged'
);
END;
oracle plsql scheduled-tasks
edited Jan 2 at 10:17
APC
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08
add a comment |
0
0
0
The below procedure runs a weekly job of dropping partitions from tables that is 6 months old. I would now like to add the logs of this job in a separate table using ALL_SCHEDULER_JOB_RUN_DETAILS. I'm not sure how to do this. Any help is highly appreciated.
PROCEDURE weekly_scheduled_job IS
BEGIN
dbms_scheduler.create_job(
job_name => 'delete_partitions'
,job_type => 'STORED_PROCEDURE'
,job_action => '"TEST_OWNER"."PURGE_LOG_PARTS"'
,start_date => 'SYSTIMESTAMP'
,repeat_interval => 'freq=WEEKLY; byday=sun;byhour=07;byminute=0;bysecond=0'
,end_date => NULL
,enabled => TRUE
,comments => 'runs weekly and looks for partitions that needs to be purged'
);
END;
oracle plsql scheduled-tasks
edited Jan 2 at 10:17
APC
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
The below procedure runs a weekly job of dropping partitions from tables that is 6 months old. I would now like to add the logs of this job in a separate table using ALL_SCHEDULER_JOB_RUN_DETAILS. I'm not sure how to do this. Any help is highly appreciated.
PROCEDURE weekly_scheduled_job IS
BEGIN
dbms_scheduler.create_job(
job_name => 'delete_partitions'
,job_type => 'STORED_PROCEDURE'
,job_action => '"TEST_OWNER"."PURGE_LOG_PARTS"'
,start_date => 'SYSTIMESTAMP'
,repeat_interval => 'freq=WEEKLY; byday=sun;byhour=07;byminute=0;bysecond=0'
,end_date => NULL
,enabled => TRUE
,comments => 'runs weekly and looks for partitions that needs to be purged'
);
END;
oracle plsql scheduled-tasks
oracle plsql scheduled-tasks
edited Jan 2 at 10:17
APC
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
edited Jan 2 at 10:17
APC
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
edited Jan 2 at 10:17
APC
120k15118230
edited Jan 2 at 10:17
APC
120k15118230
edited Jan 2 at 10:17
APC
120k15118230
120k15118230
asked Jan 2 at 10:10
p_eazyp_eazy
174
asked Jan 2 at 10:10
p_eazyp_eazy
174
asked Jan 2 at 10:10
p_eazyp_eazy
174
174
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08
add a comment |
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004432%2fhow-to-add-details-of-all-scheduler-job-run-details-in-a-table-using-stored-proc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004432%2fhow-to-add-details-of-all-scheduler-job-run-details-in-a-table-using-stored-proc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
First question is why? If you just want some details from ALL_SCHEDULER_JOB_RUN_DETAILS you can either grant the users read access to this table OR create a view that exposes just what you want them to have access to. Taking them and putting the details in another table does not make sense to me.
– Shaun Peterson
Jan 2 at 21:08