automatic deletion of items when the date passed

[Rémi]

Hello,

I have a layer with an "end date" attribute and i would like to automate the deletion of an element when the end date entered has passed. This layer is stored in a postgres database.

Do you have any idea how to proceed ?

Thanks,

[MarceloMarques]

Create a python arcpy script or an arctoolbox model builder, then schedule the script to run on the date and time that you need. Schedule geoprocessing tools—ArcGIS Pro | Documentation

[berniejconnors]

Rémi,

        This sounds like a job for a Notebook with a scheduled "task".  Once you create the python code for the deletion of the layer create a "Task" that will trigger only once to run your script on a specific date.

https://doc.arcgis.com/en/arcgis-online/create-maps/prepare-a-notebook-for-automated-execution.htm

Bernie.

[MiguelParedes]

Greetings @Rémi 

What you would probably want to use in your Python script would be the command DeleteFeatures, based on an expression that evaluates the "end date" attribute.  You would then use any of the methods suggested by @marceloRod  and @berniejconnors  to schedule the execution of the script.