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

book

Article ID: 158831

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

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.

 

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

1.      Note: Please check the following article first and see if the shared schedules are disable in the SMP Console:  TECH225678 "Scheduled Tasks are missing under the Task Scheduler even though those schedules are present on the database"

 

      1. Run the following two queries. The first of the following two 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 the article.

 

-- 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

'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

 

 

/* 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

('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

'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 (State as xml).value('(/item/scheduling/enabled)[1]', 'nvarchar (50)') = 'False'

)

 

 

2.       2. Open a command prompt box on the SMP server and go to “.\Program Files\Altiris\Notification Server\bin” 

3.      3. Run the following command which executes the “Recreate all schedules” routine.

 ScheduleProcessor {A6504EF8-164B-4ADA-A5D0-4F2584E1795B}

 OR just run NS.Weekly scheduled task.

 

 

 

Applies To

SMP 7.5 HF2 or later

 

Attachments

Disabled Schedules.sql get_app