Scheduling Dataset based on Event
By using this document user will learn how to schedule dataset with Event.
When the user wants to schedule their dataset, after some event is fired, then this type of scheduling comes into the picture. That are Events and tasks that are execute on a specified time and can be scheduled hence based trigger of an Events.
Schedule Dataset using Event: This video contains how to Schedule Dataset using Event in AIV.
👇 Scheduling Dataset in the AIV on trigger of an event:-
User want to trigger a datasetbased on external event, also event can be trigger based on execution of dataset.
When you want to schedule your dataset based on trigger of an event, then the event scheduling comes into the picture.In order to schedule the dataset based on event following steps should be followed:-
Log in to AIV using your respective credentials.
Go to Hamburger Menu
> MasterData > Dataset.
User will see the window as below:
We will be using Employees.ds in the dataset section for the purpose of understanding.
Download schedule.zip from this given schedule.zip.
Follow this link & upload the downloaded zip into AIV as shown.
You can schedule your dataset by clicking on
which will open the following dialog box:-
Go to the schedule tab as shown in the figure above. By default Time will be selected hence select schedule type Event from the drop down menu.
Trigger on Events define events on the trigger of which dataset will be scheduled.
Currently event 1 has been created for this example, you can create an event of your own by clicking on
which will open the following dialog box.
Here we have created event numbered two which is an event related to Dataset as mentioned in Event Type.
You can provide optional description of event as shown above. You can also send an email to different users when event is fired.
- For this check on event mail and enter following details
Enter Users or Roles from the dropdown.
Enter the email address of the user who you want to send the email.
Select the template from dropdown, Default for our case and hit Submit.
If you want some external event to fire click on the
which will guide you regarding necessary steps to perform the same.Now you have successfully created an event which will be visible in the dropdown as follows:-
We will use predefined event 1 for our example so select event 1.
Click on Share in case you want to share the dataset with other users or user roles.
Here the Visibility is kept Internal for this example.
If you want you dataset to be approved before sending to other users, then check Approval Require. Send Reminder specifies how many reminder should be sent.
After days specifies after how many days should the Reminder be sent again.
Approved by specifies the user name, which is Admin in our case.
You can also specify how many times the dataset should re-execute in case of failure and the interval from the drop down menu shown in the figure. For instance, in our case the dataset will be executed twice in case of failure within duration of 5 minutes.
In order to specify the output, go to the output tab as follows:-
Enter the name by which you want to schedule the dataset in the Name text area, also provide optional suffix if required.
Select the format in which you want to generate the output from the dropdown menu. We have selected pdf for our example.
- For dataset schedule user needs to select cds or stash format option as required.
You can also specify event on success/failure of the dataset which will trigger an event and execute all the waiting for event datasets. We will discuss about this in detail in the event scheduling.
You can also specify the delivery path on your computer where the dataset will be downloaded as follows.
The user can also send the file as email to the other users using following steps:-
Select the users and the roles from the drop-down menu.
Enter your email address/addresses to which you want to send the file via email.
Select a template from the dropdown, we have selected the Default template for our example.
Click on Schedule icon
in order to schedule the dataset.In case of any further help, the user can click on the
icon to access the AIV help documents.If the user is not satisfied and wants to cancel the schedule request, he can do this by clicking on the cancel button next to schedule or by clicking on
button next to the icon.The dataset is scheduled and you can check that in Requests section Requests tab, go to Waiting for event which shows where the dataset is waiting for the event to trigger.
You can trigger an event with another dataset as follows:-
Here we schedule a named Event Trigger which will trigger event 1 when run successfully.After this event is triggered, our Employee dataset will be executed.
In this manner, you can schedule your dataset based on trigger of events.