How to schedule a monthly purge of a table

MWright1
Giga Guru

I created a Delete Job.  It works except that the "Run at" condition to schedule it is a set date/time.  I need to run this job every 3rd of the month.  

 

How can I make this Delete Job run every 3rd of the month repeatedly, instead of only once.

MWright1_0-1711470613280.png

 

 

7 REPLIES 7

Mark Roethof
Tera Patron
Tera Patron

Hi there,

 

If its to maintain data, why not going for a Table Cleaner? That's the intend of a Table Cleaner.

 

Delete Jobs is a nice feature, though not intended for what you are asking.

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

Hi Mark,

The intention is to clean it at a specific time; i.e., every 3rd day of the month (which is not always 30 days).  Table Cleaner does not allow for that.

Thanks,

M

Delete Jobs is not intended for this. So perhaps than a Scheduled Job or Scheduled Flow would help you since you don't want a Table Cleaner. 

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn