Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for chief digital officers

Data Retention and Deletion Schedule Agent

Data is deleted when the policy says, with proof, and nothing under hold or in use is touched.

Data Retention and Deletion Schedule Agent: what goes in, what the agent does and what you get

What it does

A database of old customer records sits untouched for six years while the policy says three, because nobody owns deletion. This agent reads the retention policy and data inventory and finds datasets past their limit. It checks legal holds and dependencies, drafts deletion requests, and verifies after deletion that the data is gone and nothing broke. It records each decision, including skipped datasets and the reason, so an auditor can see what was kept and why. If a deletion appears to have worked but a backup or copy still holds the data, the agent reports it as unfinished. Edge case: a dataset past its limit is under a legal hold, so the agent skips it and records why. The data owner approves each deletion.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedYes, continueNoNo 1 STARTS WHEN Quarterly retention review 2 USES A TOOL Read the retention policy and data inventory 3 DOES Find datasets past their retention limit 4 USES A TOOL Check legal holds and system dependencies 5 CHECKS THE RESULT Is each dataset free of holds and activedependencies? If not: skip it and record the reason. Back to step 3. 6 DOES Draft deletion requests for each remaining dataset 7 YOU APPROVE Data owner approves each deletion 8 USES A TOOL Run or request the deletion and collect confirmation 9 CHECKS THE RESULT Does a check show the data is gone and systems stillwork? If not: investigate and report the failure. Back to step8. 10 RESULT Deletion log and retention report
Read the steps as a list
  1. Quarterly retention review
  2. Read the retention policy and data inventory
  3. Find datasets past their retention limit
  4. Check legal holds and system dependencies
  5. Is each dataset free of holds and active dependencies?If not: skip it and record the reason. Back to step 3.
  6. Draft deletion requests for each remaining dataset
  7. Data owner approves each deletionThe agent waits here for your OK.
  8. Run or request the deletion and collect confirmation
  9. Does a check show the data is gone and systems still work?If not: investigate and report the failure. Back to step 8.
  10. Deletion log and retention report

How it decides

It proposes deletion only when a dataset is past its limit, has no legal hold, and has no active dependency.

  • Never propose deletion of data under legal hold.
  • A dataset with active dependencies needs a review first.
  • Verify deletion by count and sample.
  • Keep a record of what was deleted and when.

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Retention periods
  • Hold sources
  • Verification method
  • Review frequency
  • Data owner list

What keeps you in control

It always asks you first

  • Every deletion
  • Any exception to the policy

Hard limits

  • Never delete data itself.
  • Do not delete under a hold.

It stops when

  • Done: past-due data is deleted or excepted and verified
  • Stop: the inventory is incomplete, so the agent asks owners to fill gaps

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensThe agent finds 14 datasets past limit. Three are under legal hold and one feeds a live report, so the check fails for four. It drafts deletion requests for 10. The owner approves 9. After deletion, the verification finds one table still has 2,300 rows, so the agent reports it. The owner reruns, and it passes.

More agents for chief digital officers