Tag Archives: sqljob

Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server

Posted on April 12, 2017 by erictummers

We use SSIS packages to import files. These SSIS packages are run with sqljobs. During deployment the sqljobs are created with a script. That is the plan. While running the script to create the sqljobs we got an error: Error … Continue reading →

Posted in Development | Tagged , , , | 4 Comments

Start-SqlJobAndWait

Posted on November 9, 2016 by erictummers

We have some SqlJobs that we run in our regression tests. To automate this we need something that can start the job and wait for it to finish. Based on this post we know we need to poll the sysjobhistory … Continue reading →

Posted in Test, Tooling | Tagged , , , | Leave a comment