Creating a deletion job

Creating a rule stores it with a name that you can use to refer to it later. To delete records that match the rule, you must create a deletion job.

Create a deletion rule. For more information, see Creating a deletion rule.

When you create a job, the rule is placed in the job queue and initially has a status of Pending. At 10-second intervals, i2 Analyze checks for deletion jobs to run.

Note: Do not run a deletion job while data is being ingested into the Information Store.
  1. Connect to your database as a user with the Deletion_By_Rule role.
  2. To create the deletion job, run the IS_Public.Create_Deletion_Job stored procedure and enter the name of the rule.

You can check the status of the job in the IS_Public.Deletion_By_Rule_Log view. For more information, see Verifying deletion by rule.

You can automate the rule for deletion on a schedule. For more information, see Automating deletion by rule.