how to delete a job

How to delete a job by using SQL Query analyzer?Have a look in these tables in your msdb database:

sysjobs,
sysdbmaintplan_jobs,
sysjobschedules,
sysjobhistory,
sysjobservers,
systaskids,
sysjobsteps

Keep in mind that I haven't tested this solution. Is there no way you can delete the job through enterprise manager?|||Originally posted by bmalar
Have a look in these tables in your msdb database:

sysjobs,
sysdbmaintplan_jobs,
sysjobschedules,
sysjobhistory,
sysjobservers,
systaskids,
sysjobsteps

Keep in mind that I haven't tested this solution. Is there no way you can delete the job through enterprise manager?

use SP_DELETE_JOB
for details search in BOL.|||Originally posted by harshal_in
use SP_DELETE_JOB
for details search in BOL.

A much better solution.