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

Anurag Tripathi
Mega Patron
Mega Patron

HI,

I'm assuming you have a scheduled job, if so then you can set it to run periodically -> Monthly, Select day as 3

You can also set what time zone to follow 

AnuragTripathi_0-1711470982691.png

 

-Anurag

Hi Anurag,

How can I run a Data Management Delete Job via scheduled job?  What would my "Run this script" look like?

Thanks,

M

what is Data Management Delete Job?

Is that OOB or Custom?

could you show a screenshot or something?

-Anurag

Hi Anurag,  this is OOB...   All --> System Data Management --> Delete Job

 

MWright1_0-1711476239823.png