CODEWITHSUNDEEP
sql-serversql-job
Steve
Steve

Reputation: 21

does sp_delete_job also delete the associated job step?

does sp_delete_job also delete the associated job step?

Upvotes: 2

Views: 996

Answers (1)

SS_DBA
SS_DBA

Reputation: 2423

If you script out sp_delete_job, you will see near the end of the script: (Assumption is SQL Server)

DELETE FROM msdb.dbo.sysjobschedules
WHERE job_id IN (SELECT job_id FROM #temp_jobs_to_delete)

DELETE FROM msdb.dbo.sysjobservers
WHERE job_id IN (SELECT job_id FROM #temp_jobs_to_delete)

DELETE FROM msdb.dbo.sysjobsteps
WHERE job_id IN (SELECT job_id FROM #temp_jobs_to_delete)

DELETE FROM msdb.dbo.sysjobs
WHERE job_id IN (SELECT job_id FROM #temp_jobs_to_delete)

Upvotes: 2

Related Questions