Once the ETL’s are published to SSRS they can easily be scheduled to run on intervals.

  • Create a new job
    create job
  • Give the job a name
    name job
  • Add a step to the ETL. The first step must be Setup and the last two steps must be Merge and Post Processing.
    create job step
At this step, choose the domain account that has read access to all data source and write access to the atlas-staging db.

  • When multiple steps, be sure to end the last step with ‘Quit the job reporting success’.
    multiple steps
  • Create a schedule
    create schedule