SUBSCRSCHJOBS

This table is used to record the set of scheduled jobs to be executed against each subscription or a recurring order, as specified by the shopper. Typically, jobs for cancellation of subscriptions, creation of the next child order, expiry of subscriptions after the end date are stored in this table.

Column Descriptions:

NameTypeDescription
SCHEDULED_IDBIGINT NOT NULLGenerated unique key.
ACTIONDATETIMESTAMP NOT NULLThe date when this scheduled job is to be executed by the scheduler.
SUBSCRIPTION_IDBIGINT NOT NULLThe ID of the subscription or recurring order for which this scheduled job needs to be executed.
ACTIONVARCHAR (32) NOT NULLThe scheduled job to be executed by the subscription scheduler
  • CreateChildOrder
  • Cancel
  • Expire
TIMEPLACEDTIMESTAMP NOT NULLThe time when this scheduled job was created by the subscription component
LASTUPDATETIMESTAMP NOT NULLThe time when this scheduled job record was last updated by the subscription scheduler.
STATUSINTEGER NOT NULLCurrent status of the scheduled job
  • 0- ACTIVE
  • 2- FAILED
  • 3- COMPLETED
  • 4- RETRY
  • 5- PROCESSING
PARAMETERVARCHAR (254)Parameters to be used by the subscription scheduler while executing a scheduled job. Typically used by jobs to store the last successful state of the job, in case of multi-step job execution process. This data is then used during the job recovery and retry process.
FIELD1INTEGERCustomizable
FIELD2DECIMAL (20,5)Customizable
FIELD3VARCHAR (254)Customizable
RETRYCOUNTINTEGERThe number of times this job was attempted due to failure. This value is checked against the maximum retry count specified for every job in the subscription component configuration.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SCHEDULED_IDPrimary Key
I0001371SUBSCRIPTION_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3659SUBSCRIPTION_IDSUBSCRIPTIONSUBSCRIPTION_IDCascade