Running Flyway jobs

To run the Flyway job for the first time, follow these steps:

1. From the folder of your App Factory project, navigate to Database → Flyway.

2. Select the Flyway job, and then select Build with parameters option from the menu on the left side. Alternatively, you can run the build with parameters by following either of these steps.

   • On the right-side of the job row, select the icon that represents Build with Parameters
     
   • Open the drop-down list (context-menu) for the Flyway job, and then select Build with Parameters
     

   Note: If you do not see the option, you might not have ownership permissions to the project. You can verify whether your name is listed in the Folder Owners section of the project. The Primary owner of the project can add users as secondary owners to grant permissions to the builds.
   

3. Configure the build parameters for the job. For more information about the parameters, refer to the following sections.

Source Control related parameters

Parameter	Description
SCM_URL	Specifies the URL of the source control repository that contains the Flyway scripts. The URL must be accessible by App Factory.
SCM_BRANCH	Specifies the branch of the source control repository that contains the specific version of the Flyway scripts that you want to use.
SCM_CREDENTIALS	Specifies the credentials that are used to access the source control repository.For more information, refer to Adding New Source Code Repository Credentials.

Flyway related parameters

Parameter	Description
LOCATION	Specifies a comma-separated list of paths that contain the Flyway scripts, relative to the root of the source control repository.
FLYWAY_COMMAND	Specifies the commands that are run as part of the Flyway job. For example: migrate, info, or validateFor more information, refer to Commands in the Flyway documentation.
DB_CREDENTIALS	Specifies the credentials that are used to access the database and run the Flyway scripts.For more information, refer to Adding New Database Credentials.
OPTIONS	Specifies command line options that are used with the Flyway command. For example: -schemas=dbpdblocalFor more information, refer to Command-line in the Flyway documentation.

Notification related parameters

Parameter	Description
RECIPIENTS_LIST	Specifies a comma-separated list of the e-mail addresses that must receive notifications on the results of this job.

1. After you configure all the parameters, click BUILD.

After a Build is successfully triggered, you can check the status of the build in the Build History panel. The following screenshot displays a build that is in progress (#4965) with the progress indicator icon.

You can click the icon to see the detailed output of the current build or click the progress bar to open the build page of the job. From the build page, you can click Console Output to display the detailed output of the running build.