i'm trying to schedule jobs on sql server 2000

[mit99mh]

and i want to delete a job - how do I:
1) View a list of jobs
2) Delete a job - I've tried using sp_delete_jobschedule but I get a message "Could not find stored procedure"

Any help appreciated

 

[Corran007]

SELECT *
FROM msdb..sysjobs

will give you a list of jobs.

Try sp_delete_job to kill the job. Havnt tested it, but i think this is it.

you can also use em to view them under management/sqlserver agent/jobs