Batch job and system time zone problem

[EricYu0912]

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?

[Domi]

Hi

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

[EricYu0912]

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.

[matt]

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.