The Zurich release has arrived! Interested in new features and functionalities? Click here for more

data management delete job didnt work

AEC
Tera Contributor

Hi all, I am trying to delete 927 records from the incident_sla table using "delete jobs" . I have created the job, added the criteria and executed. The job has run but the records have not been deleted.

AEC_1-1731406531676.png

 

am i being too impatient expecting the 927 records to go immediately or am i doing somehting wrong. Any pointers mcuh appreciated !

 

5 REPLIES 5

Ben131
Tera Contributor

If people are still having issues with this, I've found that if you set the run time using list edit, then the scheduled job at said run time does not get created.  
You need to set the run time on the form and then update, as there is a confirmation dialogue you need to acknowledge regarding cascade deletes. 
This becomes obvious if you add the "schedule" field to the list view, and you will see an empty value for this field on the delete jobs where you set the time in list view, vs the ones where you saved on the form which will have a sys_id present.