Hi,
in a productive ASE box, used as SAP ECC database I've got a strage case, Job Schduler.... does't work randomily... sometime works fine for days/weeks and sometime stop to works after few day from startup. The only way to solve this issue is stop/strat ASE because the command (exec sybmgmtdb..sp_sjobcontrol '','stop_js') doesn't works, it stay in running for hours... endless running:

The last SID_JSAGENT:
Confidential property of Sybase, Inc.
Copyright 1987, 2015
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:04300:04728:2017/04/16 17:30:55.79 jamain Opening jsagent connection.
00:04300:04728:2017/04/16 17:30:55.79 jamain Agent will listen on 10.2.5.250
00:04300:04728:2017/04/16 17:30:55.79 jamain SYB_JSAGENT waiting for connection
00:04300:04728:2017/04/16 17:30:56.76 jamain Job Scheduler Agent connected with Job Scheduler Task on port 4903
00:04300:04728:2017/04/16 17:30:56.79 jamain Initializing SYB_JSAGENT
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating list resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating queue resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating thread resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Initializing connection pool.
00:04300:04728:2017/04/16 17:30:57.04 jamain Server message: Changed database context to 'master'.
00:04300:04728:2017/04/16 17:30:57.04 jamain Server message: Changed database context to 'sybmgmtdb'.
00:04300:04728:2017/04/16 17:30:57.05 jamain Server message: Changed database context to 'master'.
00:04300:04728:2017/04/16 17:30:57.05 jamain Server message: Changed database context to 'sybmgmtdb'.
00:04300:04728:2017/04/16 17:30:57.06 jamain Server message: Changed database context to 'master'.
00:04300:04728:2017/04/16 17:30:57.06 jamain Server message: Changed database context to 'sybmgmtdb'.
00:04300:04728:2017/04/16 17:30:57.07 jamain Server message: Changed database context to 'master'.
00:04300:04728:2017/04/16 17:30:57.07 jamain Server message: Changed database context to 'sybmgmtdb'.
00:04300:04728:2017/04/16 17:30:57.07 jamain Creating global context.
00:04300:04728:2017/04/16 17:30:57.08 jamain SYB_JSAGENT ready.
From DBACOCKPIT we can't run scheduling such as transaction log dump or backup so sometimes trlog is full :-(
If I try to schedule a command the page stay..... in endless running


It's a Windows 2012 R2 with MSCS, it happens on all nodes. It is ASE 15.7.0.136 release.
I've already try to set "job scheduler tasks" = 25 but without success.
Have you got any idea? Do you know any check to try to solve this issue?
Thank you.
Add comment