Thursday, December 07, 2006

Scheduler job

To create a scheduler job under site level, just associate this job with "RunAlways",
example of association:
|SCHCMD_ID | CHKCMD_ID | CHKCMD.DISPLAYNAME | PATHINFO |
|-1 | -1 | RunAlways | ReturnCreditAndCloseScan |
|-2 | 12 | CheckReleaseToFulfillment | ReleaseToFulfillment |
|-3 | 13 | CheckRAReallocate | RAReallocate |
|-4 | 14 | CheckReleaseExpiredAllocations | ReleaseExpiredAllocations |
|-5 | 15 | CheckProcessBackorders | ProcessBackorders |
|-6 | -1 | RunAlways | BalancePayment |
|-7 | -1 | RunAlways | PayCleanup |
|-8 | -1 | RunAlways | PaymentSummaryGenerate |
|-9 | -1 | RunAlways | SendEmailActivity |
|-10 | -1 | RunAlways | CheckForBouncedEmail |
|-11 | -1 | RunAlways | RetryBouncedEmail |
|-12 | -1 | RunAlways | NotifyOnOrderProcessFailure |


Those not associate with -1, are store level jobs. There are checking commands to filter the jobs.

example to add a new scheduler at site level,

"
INSERT INTO SCHCMD (SCHCMD_ID,STOREENT_ID,PATHINFO) VALUES( (select min (schcmd_id)-1 from schcmd),0,'URL_COMMAND');

INSERT INTO CHKARRANG(CHKCMD_ID,SCHCMD_ID) VALUES(-1,(SELECT SCHCMD_ID FROM SCHCMD WHERE PATHINFO='URL_COMMAND'));
"

1 comment:

  1. Only for repeatable job, SCHACTIVE table will create an entry for it.

    ReplyDelete