How to delete matching records from a database

Need help Database
1

Hi ,
I am having some problems in setting up a recursive workflow at my end with no luck. I will explain as below:-

I have 2 databases

  1. SK_Video

image
image931×86 4.11 KB

  1. SK_Video_Archives

image
image904×97 5.71 KB

So what I want to do is to take Video_id_Archive data from SK_Video_Archives database and match that with Video_id_current in the SK_Video database. If a match is found in SK_Video I want to delete that record from SK_Video.

In order to achieve this I have following workflows:-

Step 1

image

Step 2

image
image696×460 20.6 KB

Step 3

image

Step 4

image

Step 5
image

Step 6

image

By running these workflows nothing is happening.

I would be obliged if you great bubblers could help me as to where I am going wrong.

Hope to hear back.

Thanks
Vijay Zutshi

2

Schedule it on a list, then inside each workflow, search for the matching ID, and delete it.