WCS | Setting up WCS Schedulers

We can setup WebSphere Commerce Schedulers in two ways,
1. Setting up through Administration Console
2. By updating scheduler information into the database through queries

In local environments, we can setup WebSphere Commerce Scheduler through the Admin console. But, moving to higher environments, it might not be possible to setup the jobs through Admin console. It can be accomplished by adding scheduler information directly to the DB.

Sample queries for inserting scheduler information to the DB,

• insert into schconfig (sccjobrefnum,scchost,member_id,storeent_id,sccrecdelay,sccrecatt,sccpathinfo,sccquery, sccstart,sccinterval,sccpriority,sccsequence,sccactive,sccapptype,interfacename,optcounter) values ((select Max(sccjobrefnum)+1 FROM schconfig),null, -1000,0, 0,0,'MySchedulerControllerCmd',null, CURRENT_TIMESTAMP, 120, 1,0,'A',default,'com.mycompany.scheduler.commands.MySchedulerControllerCmd',0);
• insert into schactive (scsinstrefnum,scsjobnbr,scsactlstart,scsattleft,scsend, scsinstrecov,scsprefstart,scsqueue,scsresult,scssequence,scsstate,scspriority,optcounter) values ((select Max(scsinstrefnum)+1 FROM schactive),(select max(sccjobrefnum) FROM schconfig), SYSDATE,1,null,null,CURRENT_TIMESTAMP,null,null,0,'I',default,0);