Post reply

Job Scheduling, trigger another job to run off completion of another

  • October 23, 2017 at 10:29 am

    #340904

    Hello, is there a way to setup one job to be triggered off the completion of another job?

    I've got an existing job that runs and loads a cube daily. I'm going to make a copy of that cubes Model and Packages, but plan to reuse the tables and views that feed the new cube. I'll ultimately pair down the new cube in size/columns, and add new fact and dims to it as well. I want the original cube to run on its scheduled job, and when completed, trigger a new job, which will run this new cube. I'm trying to save the time in not pulling over the same data again but reuse it.

    Thanks

  • October 23, 2017 at 10:41 am

    #1964825

    quinn.jay - Monday, October 23, 2017 10:29 AM

    Hello, is there a way to setup one job to be triggered off the completion of another job?

    I've got an existing job that runs and loads a cube daily. I'm going to make a copy of that cubes Model and Packages, but plan to reuse the tables and views that feed the new cube. I'll ultimately pair down the new cube in size/columns, and add new fact and dims to it as well. I want the original cube to run on its scheduled job, and when completed, trigger a new job, which will run this new cube. I'm trying to save the time in not pulling over the same data again but reuse it.

    Thanks

    Add a job step at the end of the first job based on success of the previous step to execute your new job.  Do a little research in Books Online, looking for a system stored procedure to start a job.

  • October 23, 2017 at 10:47 am

    #1964826

    Lynn Pettis - Monday, October 23, 2017 10:41 AM

    quinn.jay - Monday, October 23, 2017 10:29 AM

    Hello, is there a way to setup one job to be triggered off the completion of another job?

    I've got an existing job that runs and loads a cube daily. I'm going to make a copy of that cubes Model and Packages, but plan to reuse the tables and views that feed the new cube. I'll ultimately pair down the new cube in size/columns, and add new fact and dims to it as well. I want the original cube to run on its scheduled job, and when completed, trigger a new job, which will run this new cube. I'm trying to save the time in not pulling over the same data again but reuse it.

    Thanks

    Add a job step at the end of the first job based on success of the previous step to execute your new job.  Do a little research in Books Online, looking for a system stored procedure to start a job.

    Thank you. SP_Start_Job

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply