COPY JOB DROP was failing because I had renamed the target tables after creating the Auto Copy job. COPY JOB stores the full job_text (including schema.table). When the table name no longer exists, Redshift can’t resolve the job’s underlying metadata and the drop errors out. Renaming the tables back to their original names let me drop the jobs successfully.