Sfrgttk

Professor forcing me to attend a conference

How to make sure I'm assertive enough in contact with subordinates?

School performs periodic password audits. Is my password compromised?

Using the imperfect indicative vs. subjunctive with si

What is the oldest European royal house?

ESPP--any reason not to go all in?

Should I use HTTPS on a domain that will only be used for redirection?

Why can't we use freedom of speech and expression to incite people to rebel against government in India?

An Undercover Army

Where is the fallacy here?

New invention compresses matter to produce energy? or other items? (Short Story)

Why won't the strings command stop?

The past tense for the quoting particle って

Why do phishing e-mails use faked e-mail addresses instead of the real one?

PTiJ: How should animals pray?

Computing the volume of a simplex-like object with constraints

Under what conditions would I NOT add my Proficiency Bonus to a Spell Attack Roll (or Saving Throw DC)?

Why are special aircraft used for the carriers in the United States Navy?

Problems with rounding giving too many digits

How do we objectively assess if a dialogue sounds unnatural or cringy?

Remove object from array based on array of some property of that object

Is every open circuit a capacitor?

Is it a Cyclops number? "Nobody" knows!

Error in TransformedField

Will the job schedule obey Daylight Saving rules?

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?Agent job will not runOracle DBMS Scheduler - what if database fails?how to change the default date format in oracleOracle scheduler runs only onceHow to call a stored procedure in an Oracle Scheduler jobTop Activity in OEM reports that dbms_scheduler jobs run as the job_creator user?Updating Agent Job's Next Run ValueWay to track data deleted from databaseHow to stop the SQL Server Agent Job Scheduler with T-SQL?

0

We have an Oracle 11g Scheduler Job that was created with a start date of 08/AUG/15 05:00:00.100000000 PM AUSTRALIA/SYDNEY and a Repeat_INTERVAL of FREQ=DAILY. Sydney, as a city, observes Daylight Saving. I'm wondering if this job schedule will honour the change in Daylight Saving, or is the AUSTRALIA/SYDNEY component meaningless?

oracle oracle-11g jobs

share|improve this question

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

bumped to the homepage by Community♦ 9 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

We have an Oracle 11g Scheduler Job that was created with a start date of 08/AUG/15 05:00:00.100000000 PM AUSTRALIA/SYDNEY and a Repeat_INTERVAL of FREQ=DAILY. Sydney, as a city, observes Daylight Saving. I'm wondering if this job schedule will honour the change in Daylight Saving, or is the AUSTRALIA/SYDNEY component meaningless?

oracle oracle-11g jobs

share|improve this question

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

bumped to the homepage by Community♦ 9 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

We have an Oracle 11g Scheduler Job that was created with a start date of 08/AUG/15 05:00:00.100000000 PM AUSTRALIA/SYDNEY and a Repeat_INTERVAL of FREQ=DAILY. Sydney, as a city, observes Daylight Saving. I'm wondering if this job schedule will honour the change in Daylight Saving, or is the AUSTRALIA/SYDNEY component meaningless?

oracle oracle-11g jobs

share|improve this question

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

share|improve this question

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

share|improve this question

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

edited Mar 16 '17 at 7:46

Marco

3,74231724

edited Mar 16 '17 at 7:46

Marco

3,74231724

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

asked Mar 16 '17 at 7:40

MidnightThoughtfulMidnightThoughtful

1

1 Answer
1

active

oldest

votes

0

If you want the job to follow DST rules then you need to use a named timezone that follows the DST rules you want to use.

Yes, as you have provided the named time zone in your start date value.

Reference:DBMS_SCHEDULER or DBMS_JOB And DST / Timezones Explained (Doc ID 467722.1)

share|improve this answer

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f167319%2fwill-the-job-schedule-obey-daylight-saving-rules%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

If you want the job to follow DST rules then you need to use a named timezone that follows the DST rules you want to use.

Yes, as you have provided the named time zone in your start date value.

Reference:DBMS_SCHEDULER or DBMS_JOB And DST / Timezones Explained (Doc ID 467722.1)

share|improve this answer

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

add a comment | 

0

If you want the job to follow DST rules then you need to use a named timezone that follows the DST rules you want to use.

Yes, as you have provided the named time zone in your start date value.

Reference:DBMS_SCHEDULER or DBMS_JOB And DST / Timezones Explained (Doc ID 467722.1)

share|improve this answer

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

add a comment | 

If you want the job to follow DST rules then you need to use a named timezone that follows the DST rules you want to use.

Yes, as you have provided the named time zone in your start date value.

Reference:DBMS_SCHEDULER or DBMS_JOB And DST / Timezones Explained (Doc ID 467722.1)

share|improve this answer

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

share|improve this answer

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823

answered Mar 16 '17 at 8:43

JSapkotaJSapkota

7,5761823