| 28378 |
35 |
CPROMPT |
{Run Every 1 hourofday} |
1 |
1 |
update listing set ApprovedForDisplay = 0
where indexkey in
(
Select listing.indexkey
from
Orders, OrderLineItem, OrderLineItemExt, ItemsExt, listing
where
Orders.transactionid = OrderLineItem.transactionid and
OrderLineItem.ItemCodeId = ItemsExt.ItemCodeId and
OrderLineItem.LineItemid = OrderLineItemExt.LineItemid and
listing.orderLineItemID = OrderLineItem.LineItemID and
NextOrderDate <= getDate() and
SubscriptionPeriodsLeft = 0 and
ApprovedForDisplay > 0 and
SubscriptionEnabed > 0 and
Orders.ApprovalCode like '%approved%'
) |
|
|
2004-08-21 13:12:00.000 |
2004-08-21 13:11:19.000 | 0 |
Subscription Job ran okay |