--Main tables..
select count(*) from SCHCONFIG;
select count(*) from SCHACTIVE;
select count(*) from SCHORDERS;
select count(*) from SCHSTATUS;
--Commands---
--General---
Some tips ..
Suppose You have 2 appserver running in clusterd enviroment.Each have 2 JVM .You started one scheduler . Now how we will identify this scheduler is taken care by which Appservers'JVM .. :) ?
Don't worry Bipin have answer : Check the SCSQUEUE for details ..
This comment has been removed by the author.
ReplyDeleteschstatus.SCSQUEUE:
ReplyDeleteIndicates the job queue.
The queue name is of the format hostName:cloneId:applicationType, where the hostName and applicationType components are defined in the SCHCONFIG table and cloneId is generated.