Microsoft KB Archive/183236

= SMS: Can't Delete Systems Jobs That Are in a Pending State =

Article ID: 183236

Article Last Modified on 6/14/2005

-

APPLIES TO


 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q183236



SYMPTOMS
In the Jobs window, System jobs may remain in a Pending state. If you attempt to delete them, the following error message occurs:

Couldn't delete the specified item.



CAUSE
This problem can occur when the SQL Server transaction log used by the Systems Management Server database becomes full.



WORKAROUND
Before deleting the pending system jobs, first correct the problem with the transaction log and ensure that a backup has been made of the SMS database.

To delete these jobs, use a SQL Server query. To do this, perform the following steps:

 Use ISQL/w to execute the following SQL Server query:

Select * from Jobs where JobType = null

 Verify that the jobs listed are all "Pending" system jobs. If necessary, you can print the list of job IDs and compare the list in the Systems Management Server Administrator program. Execute the following query to delete the jobs:

Delete from Jobs where JobType = null



This procedure should remove all of the system jobs that have a Pending state.

Additional query words: prodsms

Keywords: kbdatabase kbprb KB183236

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.