campaign Expire

[09]

Hi Team,

i have created UM campaign at(11AM IST) and set 1 day as expiry; next day i logged in checked at 4PM IST. On Campaign the status is marked as OVER DUE,i ran the expiry job.  But job didnt expired. Late evening sometime campaign expired.

My question how time is calculated in campaign expiry scenarios ? 

[dgandhi]

Maybe the job didnt complete and hence the campaign was not showing as expired when you checked at 4 PM.

Anyways it would be based on the end_date in the campaign table

[09]

the job is scheduled for every 3o mins.

do you have the sql readily available? if so kindly share

[dgandhi]

Give your campaign name and try to find the output

[09]

on a side note: what is that UI or application using for Saviynt SQLs? Looks cool

[rushikeshvartak]

MYSQL  Workbench 

Validate information in DB 

select campaign_name,creation_date,end_date from campaign

[09]

its seems like a bug; campaigns are not getting expired on time.

I request you to launch the campaign and mark the expire date to 1 day. Run the below sql command to check the end date and time. Login back to saviynt at below end_date(UTC) time and Check if the campaign get expires. Ideally it should get expire after 24 hours. My observation is its taking more than 4 hours to get expired.  

NOTE: expiry job is scheduled for 30 mins and i have manually triggered the job at enddate_time as well.

select campaign_name,creation_date,end_date from campaign

[rushikeshvartak]

Validated in v24.4 its working as expected 

[09]

its not working in 24.3

[rushikeshvartak]

Validated in v24.3 and v24.1 also its working

[Manu269]

Validated in 23.10 and 23.11 als also working as expected.