fix delete job script
@@ -37,12 +37,6 @@ FROM BATCH_STEP_EXECUTION_CTX_VALS
INNER JOIN BATCH_JOB_INSTANCE ON BATCH_JOB_EXECUTION.JOB_INSTANCE_ID = BATCH_JOB_INSTANCE.JOB_INSTANCE_ID
WHERE BATCH_JOB_INSTANCE.JOB_NAME = jobName;
-DELETE BATCH_STEP_EXECUTION_CONTEXT
-FROM BATCH_STEP_EXECUTION_CONTEXT
- INNER JOIN BATCH_STEP_EXECUTION ON BATCH_STEP_EXECUTION_CONTEXT.STEP_EXECUTION_ID = BATCH_STEP_EXECUTION.STEP_EXECUTION_ID
- INNER JOIN BATCH_JOB_EXECUTION ON BATCH_STEP_EXECUTION.JOB_EXECUTION_ID = BATCH_JOB_EXECUTION.JOB_EXECUTION_ID
- INNER JOIN BATCH_JOB_INSTANCE ON BATCH_JOB_EXECUTION.JOB_INSTANCE_ID = BATCH_JOB_INSTANCE.JOB_INSTANCE_ID
-WHERE BATCH_JOB_INSTANCE.JOB_NAME = jobName;
-- Delete step executions (BATCH_STEP_EXECUTION)
DELETE BATCH_STEP_EXECUTION
@@ -58,11 +52,6 @@ FROM BATCH_JOB_EXECUTION_CTX_VALS
INNER JOIN BATCH_JOB_INSTANCE ON BATCH_JOB_EXECUTION.JOB_INSTANCE_ID = BATCH_JOB_INSTANCE.JOB_INSTANCE_ID
WHERE BATCH_JOB_INSTANCE.JOB_NAME = jobName;
-DELETE BATCH_JOB_EXECUTION_CONTEXT
-FROM BATCH_JOB_EXECUTION_CONTEXT
- INNER JOIN BATCH_JOB_EXECUTION ON BATCH_JOB_EXECUTION_CONTEXT.JOB_EXECUTION_ID = BATCH_JOB_EXECUTION.JOB_EXECUTION_ID
- INNER JOIN BATCH_JOB_INSTANCE ON BATCH_JOB_EXECUTION.JOB_INSTANCE_ID = BATCH_JOB_INSTANCE.JOB_INSTANCE_ID
-WHERE BATCH_JOB_INSTANCE.JOB_NAME = jobName;
-- Delete job executions (BATCH_JOB_EXECUTION, BATCH_JOB_EXECUTION_PARAMS)
DELETE BATCH_JOB_EXECUTION_PARAMS
