cannot delete a scheduled job

Hot Topic

Complex Join
Is there any sample code which creates login and user of one database using SMO?
SP1 Database Services failed to install
Remove "top of report" when published via ASP call
Transform　sql server mobile edition database to sqlce2.0 format.
Can a SSIS package join an external transaction?
installation failure (just installing database server)
MySQL function equivalent
Why？
sub-reports don't start in the first page

SQL Server

Script Task TimeOut
Missing SQL Server Project template
Audit task
is it possible to have variant condition clause in procedure?
bcp using native client
populating numbers instead of description in performance objects
File Enumerator does not show after install of SP1
Bulk Insert won't compile if file doesn't exist, no Try Catch either
Looping each record
can't run dta

cannot delete a scheduled job

when I try to delete a scheduled job I just get an error. I'm using the administrator account.

Any ideas




Answer this question

cannot delete a scheduled job

  • Daniel Celeda

    I think you need to delete the plan (under Management > Management Plans) instead of deleting jobs associated with this plan.

    But I'm no expert in maintenance plans, you may try Sql Server Tools forum - http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=84&SiteID=1 for Database Maintenance questions.

  • Bravo

    What is the error message

  • Christoc

    delete statement conflicted with reference constraint "FK_subplan_jobid". The conflict occurred in database MSDB in table dbo.sysmaintplan_subplans column 'job id'. The statement has been terminated. Microsoft Sql Server error 547.

    I am logged on as administrator.

    Any ideas



  • cannot delete a scheduled job
Answer this question