2

does sp_delete_job also delete the associated job step?

Steve
  • 21
  • 1

1 Answers1

2

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)
SS_DBA
  • 2,403
  • 1
  • 11
  • 15