Question

4
Replies
181
Views
Close popover
Vironica ms (Vironicam)
M1 Limited

M1 Limited
SG
View ProfileSend Message
Vironicam Member since 2017 14 posts
M1 Limited
Posted: May 23, 2019
Last activity: June 10, 2019
Closed
Solved

pega table store list of scheduled campaign

Hi All

which pega table store list of scheduled campaign ?

** upcoming scheduled campign which going to run

please advise

Regards

V

Pega Marketing
Close popover
Moderation Team has archived post
Posted: 1 year ago
Close popover
Vironica ms (Vironicam)
M1 Limited

M1 Limited
SG
View ProfileSend Message

thanks Kevin and Chin2 for reply;


i cant find the next schedule/ upcoming date info in MKT_WORK ? which field ?


please advise


 


thanks and regards


 

Accepted Solution

Posted: 1 year ago
Close popover
Nishitha Chintala (chinn2)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN
View ProfileSend Message

Hi,


You can run the following query to get upcoming and currently running campaigns details.


SELECT * FROM pegadata.mkt_work

where pystatuswork='Pending-Running';   (here pegadata is my schema name)
Share this page Share via LinkedIn Copying...
Copied!