Scheduled tasks disappear from Scheduled Task Library after upgrading to newer SMP release

Products

IT Management Suite

Issue/Introduction

After upgrading, some or all of the major scheduled tasks such as "NS.Delta Resource Membership Update.{67431011-a4c3-457c-b4ff-fa7ce7812260}", were no longer displayed in the server’s Scheduled Task Library.

Environment

ITMS 8.x

Cause

It is not known why this occurred, because the installation went through with no errors or evidence that anything went wrong. It was only noticed when the filters, targets and packages etc stopped getting refreshed.

It seems to be a relatively rare occurrence, but has been reported enough times to trigger a defect report linked to this article.

Resolution

Note: Please check the following article first and see if the shared schedules are disable in the SMP Console:

161324 "Scheduled Tasks are missing under the Task Scheduler even though those schedules are present on the database"

Run the following two queries. The first of these SQL queries, when run against the database, will identify the affected schedules (out-of-box schedules). The second query will turn the affected schedules back on. A file containing the raw queries in txt format is also attached to this article.

Query 1

-- Important schedules that are set as disabled.

select i.Name, i.Guid, isnull (i2.Name, 'No Parent Folder'), CAST (i.State as xml).value('(/item/scheduling/enabled)[1]', 'nvarchar (50)')

from Item i

join ItemClass ic on ic.Guid = i.Guid

join Class c on c.Guid = ic.ClassGuid

left join ItemFolder ifold on ifold.ItemGuid = i.Guid

left join Item i2 on i2.Guid = ifold.ParentFolderGuid

where i.Guid in

('77B1616A-9CE7-415E-8BA5-7B789ECBE45F',--Business Hours

'BCE0A681-47D2-4702-ACCB-6C248940639A',--Complete Resource Membership Update

'8E6C708E-18BC-4EF9-ACEA-2DE826C4F3B9',--Daily

'67431011-A4C3-457C-B4FF-FA7CE7812260',--Delta Resource Membership Update

'97829B6D-9541-42A3-9415-51E3234AE8A2',--Half-Hour

'978E9B66-9541-42D3-9410-51E3A34AE6A2',--Hourly

'7FB7EA2E-3EEB-4F0E-A52A-15EE0775EACB',--Internal data consistency check

'231E71F9-E613-42BC-8979-79C86BEADE33',--Item to delete schedule

'449B48FF-CAD6-4B08-82DB-4E0E8D3D7706',--Monthly

'6B2FBF7B-BB55-44AE-A9B5-495DAD295E5D',--NS Process Monitoring Schedule

'BD6BF880-BFAE-4DAD-B746-E8BE99F3B8A8',--Package Refresh

'C1AA60E3-43CF-49B8-A7CB-8531B06BF871',--Policy Filter Update

'5834AE07-1160-4037-8A25-67AEBF6A254E',--Quarter-Hour

'A6504EF8-164B-4ADA-A5D0-4F2584E1795B',--Recreate all schedules

'18B34F30-9B3A-4E26-BB11-42E0FBE15610',--Resource Target Purge Schedule

'4862228F-A789-43F2-9EA2-5C3E3BABFDBC',--Resource Delta History Generation Policy

'AB7141ED-E03A-48E5-9051-A71B5912B7F2'--Weekly

)

and CAST (i.State as xml).value('(/item/scheduling/enabled)[1]', 'nvarchar (50)') = 'False'

order by i.Name

Query 2

/* Enable important schedules that have been disabled.

NOTE: It is best practice to have a current backup of the database before running any scripts that directly modify the database.

*/

UPDATE Item SET [State] = replace(cast([State] as nvarchar(max)),

'<enabled>False</enabled>',

'<enabled>True</enabled>'),

ModifiedDate = getdate()

WHERE Guid IN

(

select Guid

from Item

where Guid in