How to trigger scheduled data import using business rule

[msc]

Hi All ,

How to trigger scheduled import set using business's rule when data source is loaded new attachment file.

[shloke04]

Hi @msc 

why do you need to trigger it via Business Rule? As Scheduled Import set will automatically run as per the time defined in the job as shown below for example:

Also to mention that when data is imported or loaded every Import has a Data source linked to it and that data source will have a Transform Map linked to the Target table to which you need to transform the incoming data to.

So can you explain on what is the need or use case you need a BR here?

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[msc]

Hi Shloke Here for the purpose is the excel file came from outlook mail from one month or two months or any time so at that time only i need to execute this data source and also here I created one datsoure that have a particular sysid right And also i created inbound email action , inthat target table is datasource and here the script is the previous excel file is removed and the newly attached file will added here

[shloke04]

@msc 

You can refer the below blog from ServiceNow guru on how to trigger a Scheduled job from a Business rule or a server script:

https://servicenowguru.com/scripting/execute-scheduled-jobs-script/

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke