topic Re: Batch job and system time zone problem in Application Development and Automation Discussions

Batch job and system time zone problem

EricYu0912 — Mon, 20 Aug 2018 08:38:23 GMT

Hi all,

I have a problem with batch job setting about the time zone.

My database data is stored in UTC while the SAP system is CET.

I want to run a report as batch job on 00:00:00 in UTC(for selecting the data from DB), it means CET could be 01:00:00 or 02:00:00(depands on if day light saving time). How can I set the batch job running time?

Can anyone help me out?

Re: Batch job and system time zone problem

Domi — Fri, 28 Sep 2018 22:01:03 GMT

That's the wrong approach!

Your report has to select the correct data (with the required timestamp) regardless of the execution time!

SY-DAYST may be usefull (https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abentime_system_fields.htm)

Also the planned job time is kind of suggestion - if there are no free resources (eg batch processes) or a system downtime, your job will start delayed (or even never "No Start After")

regards

Domi

Re: Batch job and system time zone problem

EricYu0912 — Thu, 04 Oct 2018 03:00:43 GMT

Hi Domi,

Actually, what I need is to get the data of yesterday, so I think my approach would work in my case, which means my batch job would always run after 00:00:00 UTC.

But anyway, SY-DAYST would be useful, thank you for the suggestion.

Re: Batch job and system time zone problem

matt — Thu, 04 Oct 2018 06:26:27 GMT

Just run in at 11:00pm CET? Or must it be started as soon as midnight UTC? If that's the case, write a program that runs at 10:00pm CET. It figures out whether daylight saving is operational, and if it is, submits the actual job to run immediately, and if it isn't submits the actual job to run in one hour.