Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Adobe Campaign Classic Scheduler

Avatar

Avatar
Validate 1
Level 1
nithin2015
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
nithin2015
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
nithin2015
Level 1

15-01-2020

Hello Community,

In this scenario we are trying to pull data from adobe cloud and save it in AWS S3 bucket as a pipe delimited file.

  • In the current situation the Scheduler is just grabbing everything from the DataBase and storing it in the S3 bucket...
  • Every-time it run's, The data transfer has to start from where it has left out and grab from that date onwards.
  • Should the Incremental query has to be linked to a Scheduler in order to define the execution frequency of the workflow, and therefore the query ?
  • How can we do it in a workflow ? 
Adobe Campaign Adobe Campaign Classic

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

16-01-2020

Hi Nitin,

 

You should use scheduler available within the incremental query activity.

If this is not possible for some reasons then you can use scheduler +JS to keep track of the last execution date and a standard query activity to use that execution date from JS in a workflow.

 

Regards,

Amit

Answers (1)

Answers (1)

Avatar

Avatar
Level 1
random_developer
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
random_developer
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
random_developer
Level 1

18-01-2020

Hey Nitin,

let me reiterate the problem.

1. let's say customer wants to extract the data from 1st Jan to till now [18th Jan] and first time workflow was ran on 14th hence the data till 14th was exported.

2. Next time workflow ran on 15th so rather than sending out the data from 1-15 Jan, you want to export the data post 14 Jan[ last execution] but before 15 Jan, right?

solution:

create a option with name last run

random_developer_0-1579362809811.png

once this is created put a scheduler and write a js code to read the option.

random_developer_1-1579363147917.png

1.schedule to trigger the workflow everyday.

2. JS code- read option and store last run date and also getCurrentdate() on two separate event variable.

3.pass the last run date in query activity like : last modified data on or after $datetime(vars/@lastRepDate)

4. Once done then update the option using code: setOption(vars.optionName, vars.nextRepDate); // added on end activity advanced tab.

 

wasim