Thursday, March 31, 2011

Things should know about - Scheduler in WCS

--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 ..

2 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. schstatus.SCSQUEUE:
    Indicates 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.

    ReplyDelete