cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any sybase command or stored procedure to know the status of the job scheduler

former_member207908
Participant
0 Kudos

Is there any sybase command or stored procedure to know the status of the job scheduler

Accepted Solutions (1)

Accepted Solutions (1)

former_member187136
Contributor
0 Kudos

Rajesh,

Please find the process to get ensured Job_Scheduler up and running.

use master

go

select * from sysprocesses where program_name like 'JS Agent%' or cmd = 'JOB SCHEDULER'

go

use sybmgmtdb

go

select * from js_jobs

go

select * from js_scheduledjobs

go

use saptools

go

select * from DBH_CONFIG

go

select * from ATM_CONFIG

go

To Start and Stop the Job Scheduler:

use sybmgmtdb

go

exec sp_sjobcontrol @name=NULL,@option="stop_js"

go

dbcc traceon(3605,3641)

go

exec sp_sjobcontrol @name=NULL,@option="start_js"

go

Regards

Kiran Kumar A

former_member207908
Participant
0 Kudos

Dear Kiran,

Thank you for your wonderful response.

Answers (1)

Answers (1)

perotto_westheim
Explorer
0 Kudos

Hi,

Addition to the reply from Kiran you can somehow see the status of the JS in Sybase Central and SCC/Sybase (now SAP) Control Center gui's where the Stop or Start button is "highlighted". This gives you a clue if it is stoped or started, but the best way to be sure is to select from sysprocesses.

Regards!

Per Otto Westheim