AnsweredAssumed Answered

How to view/export Nintex Workflow Schedules

Question asked by knoll-mb on Mar 19, 2018

In preparation of migrating SharePoint 2013 -> 2016 we want to export all Nintex workflow schedules as all Schedules were lost during migration of our test environment. 

 

After some investigation I found Nintex storing the schedules in table "WorkflowSchedule". 

Is there a way exporting the schedules to the new database? If not - is there a way of exporting them in a way to be able to read them and create all of them (got 59 schedules in prod system to migrate) by hand in the new environment? 

 

This is what can be found in WorkflowSchedule table by SQL:

 

SELECT *  FROM [WorkflowSchedule]

 

ScheduleId ItemId ListId WebId SiteId WorkflowId WFName NextRunTime Schedule StartData ModifiedBy IsBroken IdentityUser
1 -1 00000000-0000-0000-0000-000000000000 E0A4DA70-C536-4730-8742-E8254BF29EEF 6B191DA0-C8E3-45B4-8DAB-EC3C56FCCC0F 2930EBBA-4202-4B94-BBF2-DF3D3956053E Create Element every hour 2018-03-19 12:00:00.000 <?xml version="1.0" encoding="utf-16"?><ScheduleDetails xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><MaximumRepeats>0</MaximumRepeats><WorkdaysOnly>false</WorkdaysOnly><CompletedInstances>0</CompletedInstances><RepeatInterval><Type>Hourly</Type><CountBetweenIntervals>1</CountBetweenIntervals></RepeatInterval><PreviousRuntime>0001-01-01T00:00:00</PreviousRuntime><IntendedNextRuntime>2018-03-19T12:00:00Z</IntendedNextRuntime><EndOn>NoLimit</EndOn><StartTime>2018-03-19T13:00:00</StartTime><EndTime>2018-03-19T14:00:00</EndTime></ScheduleDetails> <dfs:myFields xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:dms="http://schemas.microsoft.com/office/2009/documentManagement/types" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:q="http://schemas.microsoft.com/office/infopath/2009/WSSList/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2009/WSSList/dataFields" xmlns:ma="http://schemas.microsoft.com/office/2009/metadata/properties/metaAttributes" xmlns:pc="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dfs:queryFields /><dfs:dataFields><d:SharePointListItem_RW></d:SharePointListItem_RW></dfs:dataFields></dfs:myFields> i:0#.w|domain\useraccount 0 i:0#.w|domain\useraccount

Outcomes