Versions Compared

Old Version 46

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Insert excerpt
_Banners
_Banners
nametaskPlan
nopaneltrue

This page is for data modellers, application designers and system administrators. It explains how to create a task plan, which will run one or more tasks.

Overview

When working with data, applications and IT systems, there are routine processes that you need to run. PhixFlow makes it easy for you to set up and manage these processes using task plans, to which you add Tasksadd tasks.

See Also

Panel
borderColor#7da054
titleColorwhite
titleBGColor#7da054
borderStylesolid
titleSections on this page
Table of Contentsindent12pxstylenone


Running Task Plans

Excerpt
You can run a task plan:
  • manually, using the property tab toolbar button 
    Insert excerpt
    _taskplan_start
    _taskplan_start
    nopaneltrue
    .
  • automatically at a scheduled date and time, using the Scheduled check box and related Schedule section.
  • by linking it to an application action, in the action properties → Run Task Plan section; see Table-Action.
    When the user clicks something in the application, such as a button or
item in the application
  • a data row, the task plan runs.

When a task plan runs,

the listed

its tasks are run in the order they are listed.

You can optionally set up a list of users who will receive an email about the outcome of running the task plan.

Task Plan Properties

Insert excerpt
_standard_settings
_standard_settings
nopaneltrue

The property tab toolbar includes the 

Insert excerpt
_taskplan_start
_taskplan_start
nopaneltrue
 button. Click this to manually run the task plan.

Basic Settings

FieldDescription
NameThe name of the task plan.
Enabled

Insert excerpt
_check_box_

ticked

tick
_check_box_

ticked

tick
nopaneltrue
 to indicate the task plan configuration is complete and it can be run.

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to prevent the task plan being run. For example, during maintenance, you may not want the task plan to run at

it's

the scheduled time.

Scheduled

Insert excerpt
_check_box_

ticked

tick
_check_box_

ticked

Tasks

A list of tasks in the task plan; see Task. To add a task, click Image Removed and select the type of task you want to add; see Types of Task.

tick
nopaneltrue
 to add a Schedule section to the properties, where you can configure the day and time that the task plan will run. 

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 for task plans that you want to run manually. 

Suspend on Failure
If ticked, the Suspended flag will be set to true if any error messages are generated by the task plan during execution.SuspendedIf the field Suspend on Failure is ticked, this box will be ticked by the system if any error messages are generated when the task plan is executed. This indicates that there is a problem which should be fixed before the Task Plan is run again. The next time the task plan runs, if this flag is still ticked, it will simply generate a one line error message in the log file stating that it cannot run as it has been suspended. To un-suspend the task plan, untick the field.

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 to set PhixFlow to automatically tick the Suspended checkbox if running the task plan generates an error message. You can find the error messages in the log file; see Server Log Files.

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 so that a task plan can report errors without preventing the next run.

Suspended

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 prevents the next run of the task plan. PhixFlow automatically ticks this box if the task plan generated an error message on its previous run. This means the task plan will not run again until you have:

  • resolved the problem that caused the error message
  • and unticked the Suspend checkbox.

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 indicates the task plan can run as no errors were reported in the previous run.

Protect on import

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to allow this task plan to be updated or deleted by import from another PhixFlow instance.

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 to retain the Enabled, Scheduled, Suspend on Failure, Suspended and Schedule settings if this task plan is imported from another PhixFlow instance.

Expand
titleMore ...

Insert excerpt
_protect_import
_protect_import
nopaneltrue


Tasks

This section has a toolbar with standard buttons. The grid contains a list of of tasks in the task plan. To create a task and add it to the list:

  1. Click 
    Insert excerpt
    _new
    _new
    nopaneltrue
    . PhixFlow displays a list of task types; see Types of Task.
  2. Select a task type.
  3. Complete the task properties; see Task.

To remove tasks, use the toolbar button 

Insert excerpt
_delete
_delete
nopaneltrue
.

Schedule

This section is displayed when Basic Settings → Scheduled is ticked. Specify the day and time

at

on which the task plan runs.

In the fields, you can enter:

  • an explicit value
, for example,
  • : 6
  • a range
, for example,
  • : 9-12
  • a repeating group
, for example,
  • : 5/10
.

  • This is equivalent to 5,15,25,35 etc.
  • a comma-separated list of single values, ranges or repeating groups
. For example,
  • : 1,3-5,10,20/5
  • a wild card
*, meaning
  • to mean all values: * 
    Note: You cannot use a wild card in the Seconds field.

Tip

The Schedule section has fields for Day of Month and Day of Week . These fields are mutually exclusive. Use one to specify a day, and enter a ? to indicate no value  is specified in the other.


FieldDescription
Seconds
Seconds element
Enter the seconds part of the scheduled
date/
time,
e.g.
for example, 0-59.
Minutes
Minutes element
Enter the minutes part of the scheduled
date/time e.g.
time, for example, 0-59.
Hours
Hours element
Enter the hours part of the scheduled
date/
time
, e.g.
, for example, 0-23.
Day of Month
Day of Month element of

Enter the day of the scheduled date

/time, e.g. 1-31.Day of Month can be specified relative to the end of the month e.g. 'L',

. You can enter:

  • number to specify the date. The day number can be 1 to 31
    Note: A date of 31 will not run the task plan in months that only have 28, 29 or 30 days
    • for example, 20 runs the task on the 20th day of the month
    • for example, 1-31 runs the task plan every day
  • L to specify the last day of the month
  • L-number to specify a day relative to the last day of the month
    • for example,
or '
    •  L-2
',
    •  runs the task plan two days before the last day of the month
.A day of month followed by a 'W' means
  • numberW to specify the nearest week
-
  • day to
that day in the same month e.g. '15W' means if the 15th falls on a Saturday the task plan will run on the preceding Friday, and if it falls on a Sunday it will be moved to the following Monday, '1W' means
  • a date, for example: 
    • 1W runs the task plan on the first week-day of the month
    • 15W, where the 15th is a:
      • Saturday, runs the task plan on Friday 14th
      • Sunday, runs the task plan on Monday 16th
    • 1W runs the task plan on the first week-day of the month
, and 'LW' means
  • LW runs the task plan on the last week-day
in
  • of the month
.

Day of Week and Day of Month are mutually exclusive. One must be set to '?' (meaning no value specified), and the other defines the days that this Task Plan runs on.

Month

Month element of the scheduled date/time, e.g. 1-12

Month can also be specified as short names e.g. JAN,OCT-DEC

Day of Week

Day of week element of the scheduled date/time, e.g. 1-7. The week starts on Sunday. So Sunday = 1, Monday = 2, etc.

Day of Week can also be specified as short names e.g. MON,WED-FRI

A day of week name or number followed by an 'L' means the last day of week in the month e.g. 'FRIL' means the last Friday, '2L' means the last Monday.

A day of week name or number followed by a hash ('#') and a number means the Nth day of week in the month e.g. '2#2' means the 2nd Monday in the month, 'FRI#5' means the 5th Friday in the month - if there is no 5th Friday in the month, that is equivalent to specifying no day of week.

If the '#' character is used, there can only be one expression in the day-of-week field, so "3#1,6#3" is not valid, since there are two expressions.

Day of Week and Day of Month are mutually exclusive. One must be set to '?' (meaning no value specified), and the other defines the days that this Task Plan runs on

YearYear element of the scheduled date/time, e.g.
  • ? to indicate no value is specified here when you use the Day of Week field instead.
Month

Enter the month of the scheduled date. You can enter the months as:

  • a number or number range. Numbers are 1 to 12. For example:
    • 5 runs the task plan in May
    • 1-12 runs the task plan every month
  • its short name, for example, JAN,MAY,JUN,DEC. You can specify a range of months, for example JAN-MAR.
Tip

The month short names must be in block capital letters.


Day of Week

Enter the day of the scheduled date. You can enter:

  • number to specify the day as number from 1 to 7, where:
    • 1 is Sunday
    • 2 is Monday
    • 6 is Friday
    • 7 is Saturday
    • for example, 20 runs the task on the 20th day of the month.
    • for example 2-6 runs the task plan every week-day
  • the short day name, for example MON,TUE,FRI,SUN. You can specify a range of days, for example:
    • MON-FRI runs the task plan on week-days.
  • L as a suffix, to specify the last week-day in the month, for example:
    • FRIL runs the task plan on the last Friday of the month
    • 2L runs the task plan on the last Monday of the month
  • #number as a suffix, to specify one Nth weekday in the month. For example:
    • FRI#1 runs the task plan on the first Friday of the month
    • 4#2 runs the task plan on a Wednesday, when it is the 2nd Wednesday of the month
    • FRI#5 runs the task plan on the fifth Friday of the month. If there is no fifth Friday, the task plan does not run.
    • 2#1, 1#3 is not valid, as it specifies more than one value.
  • ? to indicate no value is specified here when you use the Day of Month field instead.
YearEnter the year of the scheduled date, for example, 2020. You can specify a range of years, for example, 1970-2099.

Anchor
email_user
email_user
Send By Email

You can set up an automated email to be sent with the results of a task plan run.

Emails are generated in an outbound queue and are sent by a separate email demon process. If the demon cannot send the emails immediately, for example, because the email server is down, the email demon process will try to re-send periodically until:

  • either it succeeds
  • or
until
  • it exceeds a timeout period
has passed
  • .
FieldDescription
Email From
The
Enter the email address from which the generated email will appear to be sent.
Subject Expression

Enter

a 

a PhixFlow

Expression to create the Email Subject.

expression to create the email subject. The expression must evaluate to a plain text string; see Expressions and PhixScripts.

Use the internal variables _errors, _warnings, _messages, _suspended  and _taskPlan.

Email as HTML
Insert excerpt
_email_as_html
_email_as_html
nopaneltrue
Message Expression

Enter a

PhixFlow Expression to

PhixFlow expression to create the message body of the email. Email messages can have unlimited characters. The expression must evaluate to a plain text string; see Expressions and PhixScripts.. When Email as HTML is ticked, the string can include HTML tags, for example to format text or provide links.

Use the internal variables _errors, _warnings, _messages,  _suspended and _taskPlan.

Notification
A

This section has a toolbar with standard buttons. The grid contains a list of the

users that will be notified with the results of

notification rules that belong to the task plan.

This section contains the additional button Image Removed - this will bring up the list of users in PhixFlow. Drags users into this list to add them as an email recipient. 

Doing this will add the users with a blank notification rule, which means that the users will get an email every time this task plan runs. Edit the users in the list to update the notification rule, or add users manually using the Image Removed button. For each user notification rule configure the following settings:

FieldDescriptionUserSelect a user configured in PhixFlow from the drop down list.Email As

Choose one of:

  • To
  • Cc
  • Bcc
Expression

An Expression which governs whether the recipient will receive the email generated by the Task Plan on completion. The internal variables _errors, _warnings, _messages and _suspended can be used in the User Notification Expression.

In particular, the _suspended variable can be used to send an email to a recipient only if a Task in the Task Plan failed - leading to the Task Plan being suspended. While a Task Plan is suspended, no further emails will be sent even if the Task Plan is scheduled to run.

Further, using the _errors variable, this expression can be set up so that a recipient is sent an email only if there are more than a certain number of error messages.

To create and add a notification to the list, cick

Insert excerpt
_new
_new
nopaneltrue
. PhixFlow opens the properties tab for a new User Notification Rule.

  1. In Basic Settings →  Email As select one of:
    • TO
    • CC
    • BCC
  2.  Optionally add an expression to specify the conditions under which the email is sent. To specify sending an email based on logged messages, use the internal variables:
    •  _errors: to send an email if there are any errors, or more than a specified number of errors
    •  _warnings: to send an email if there are warnings
    • _messages: to send an email if there are any messages
    • _suspended: If you have ticked Suspend on Failure, you must send an email to someone who can resolve the issue that caused the task plan to fail.
  3. In the Users section, click
    Insert excerpt
    _user
    _user
    nopaneltrue
     to open a list of users. Drag users from the list into the grid. 
  4. Click 
    Insert excerpt
    _finish
    _finish
    nopaneltrue
     to save and close the user notification rule.

To remove a user notification rule from the task, use the toolbar button 

Insert excerpt
_delete
_delete
nopaneltrue
.






Live Search
spaceKey@self
additionalnone
placeholderSearch all help pages
typepage

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel3
indent12px
stylenone