Transcript:
0:00 [Music]
0:05 hi everyone welcome to the fourth video
0:07 in this series on the North52 scheduler
0:10 in this video we are going to create a
0:12 schedule that will send a daily report
0:15 of fail system jobs to the system
0:19 administrators to do this we will need
0:21 to create a global action that creates
0:23 an email a formula to populate that
0:26 email with the relevant information and
0:28 a schedule to call that action once a
0:32 day navigate to settings n52 formulas
0:36 and create a new formula we're going to
0:40 set up our formula to populate the email
0:42 in the global
0:44 action this formula will be of type
0:47 process Genie running on an email with a
0:50 display format of string save the
0:53 formula
0:54 now we will need to find any failed
0:57 system jobs so we will use an advanced
1:00 find to generate the fetch
1:03 XML we look for
1:05 workflows that have a status reason of
1:09 failed and a modified on date of
1:13 today we download the fetch XML and open
1:17 it in
1:18 notepad copy out the fetch XML and click
1:22 on the fetch XML tab on the left hand
1:25 side of your
1:26 formula click the plus icon to open a
1:29 new window and paste in the fetch
1:33 XML set the name to be find failed
1:36 system jobs
1:42 today hit save and
1:48 close next we will use the create HTML
1:52 table function to generate the list of
1:55 Records The Entity collection in this
1:58 instance will will be returned by the
2:00 fetch XML so we use a find records FD
2:05 function we select the name of the fetch
2:08 XML query from the fetch XML
2:11 tab then we use set column order to
2:15 determine how we want the colums to
2:17 display in the table on the
2:19 email we will use
2:22 name started on regarding object
2:28 ID owner ID
2:31 state
2:32 code status
2:34 code and operation
2:37 type we enter the URL of our Dynamics
2:40 365 instance as the third parameter and
2:44 then close out the
2:51 function save again and then we run a
2:54 syntax check on our formula to make sure
2:57 we have no typos Etc
3:02 take note of the formula short code as
3:04 you will need this for our
3:08 workflow navigate to settings processes
3:12 create a new
3:14 process we will name it daily failed
3:18 system jobs
3:24 notification and we set the category as
3:27 action and the entity to none
3:31 now due to the bug with how Microsoft
3:33 executes fetch XML at runtime to look up
3:36 the name of actions we have to add the
3:39 unique name to the end of our process
3:42 name so the name of our action is now
3:46 daily failed system jobs
3:48 notification Space newcore daily failed
3:52 system jobs
3:54 notification it's just the way it
3:58 is the first step in our workflow will
4:00 be to call the North52 formula we
4:03 created so we add a North52 process
4:07 Genie step and we will call it generate
4:10 HTML
4:15 table click on the set properties and
4:18 enter the short code for our
4:24 formula The Next Step will be to send
4:26 the email
4:30 we set the
4:32 sender and the
4:34 recipient you can add additional system
4:36 users here for as many system admins as
4:40 you have select a simple subject and add
4:44 a line to the body for example this is
4:47 the list of fail jobs from yesterday
5:07 next we select create HTML table and
5:11 then add the result string to the body
5:14 of the email this will inject the table
5:17 we created in the North52 process
5:22 Genie save and activate and then close
5:25 the action
5:35 next we will create our
5:37 schedule navigate to settings iN52
5:41 schedules and create a new
5:44 schedule our schedule will be called
5:47 failed system jobs
5:53 notification and set the frequency to be
5:56 daily we Mark the schedule as a global
6:00 action and select the action we want to
6:04 run we set the start date to be 11:00
6:07 p.m. tonight and the schedule will now
6:10 trigger at 11:00 p.m. every night
6:13 sending out the email to the system
6:19 administrators this is an example of
6:21 what that email will look
6:25 like if you have any questions or need
6:28 any assistance please contact us at
6:31 supportor 52.com or visit support.
6:36 52.com