cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to view/export Nintex Workflow Schedules

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" xmlnsSmiley Tonguec="http://schemas.microsoft.com/office/infopath/2007/PartnerControls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><dfs:queryFields /><dfs:dataFields><dSmiley FrustratedharePointListItem_RW></dSmiley FrustratedharePointListItem_RW></dfs:dataFields></dfs:myFields> i:0#.w|domain\useraccount 0 i:0#.w|domain\useraccount

Labels: (1)
0 Kudos
Reply