Wrong excecution time DB13 (Sybase)

[jakobweimer]

Hi,

as the title of this thread says, i am having a little trouble with the excecution of planned sql commands in the transaction DB13.

After restarting the system, everything works fine for a while, means logs and dumps are written to the share.

Max. 24 h later, DB13 runs with 2 hours difference to the actual time and all planned actions are not excecuted anymore.

I already checked the time of the server (application and database running on the same server) but that is correct. (Windows Server 2008)

System-> Status shows also the correct time, but in DB13 all commands run with a delay of 2 hours..

Any ideas why db13 does not run at the correct time?

Is it possible that sybase is updating the databasetime with a wrong timezone?

Best regards

Jakob

Sybase 15.7

Windows Server 2008

NetWeaver  7.40

[jakobweimer · Accepted solution]

Problem solved: the job scheduler was not running

Solution:

Execute the command exec sybmgmtdb..sp_sjobcontrol '','start_js' as "sapsa"

[jakobweimer]

Hi again,

are there any new suggestions?

Maybe the screenshot below explains the problem a little bit better.

Best regards

Jakob

[divyanshu_srivastava3]

Hi Jakob,

Check time zone setting in STZAC.

Check usre's time zone.

How many background processes are free at that time ?

Refer:

1943027 - "Scheduling failed" status in DB13/DBACOCKPIT

1887490 - SYB: DB13 shows successful jobs with status 'Failed' (2)

544881 - Composite SAP note: Time-driven jobs do not run

Regards

[jakobweimer]

- In transaction STZAC the timezone is UTC

- The user i used for planning the sql statements in db13 has no configuration assigned but in STZAC standard timezone for user is also set to UTC.

- There are 4 background processes and 3 of them are free

[karthikeyan_natarajan4]

Hi Jakob,

Have you checked sap kba 1943027 - "Scheduling failed" status in DB13/DBACOCKPIT

and value of parameter "rdisp/btctime"

[former_member188883]

Hi Jakob,

Is there any timezone maintained for the user under db13 is executed ? Please check the settings in SU01.

Regards,

Deepak Kori

[jakobweimer]

The user i used for planning the sql statements in db13 has no timezone assigned.

So I think it´s the standard configuration of the transaction STZAC wich is UTC?