Post reply

Deleting a Job and Job Schedule

  • July 24, 2006 at 10:22 am

    #153105

    MSSQL2000

    I need to write a proc that will delete a specific Job and it's linked Job Schedule.

    I know to use the existing stored procs to update or add a job, but I do not see one for delete or drop.  This leads me to assume that the proper way to delete through t-sql is using the standard DELETE FROM.  Is this correct?

    Just want to confirm before I proceed.  Thanks!

  • July 24, 2006 at 10:38 am

    #651140

    check msdb..sp_delete_job in bol

  • July 24, 2006 at 10:40 am

    #651141

    Aah, my eyes have deceived me!  Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply