Activity overview
Latest activity by cmmc
How do I deploy column changes on a large table with a lot of indexes without timing out?
We use DevOps with Change Automation to deploy changes to our environments. I have a 77GB table with a lot of indexes and we need to alter the table to add a column. This change needs to be deploye...
Kendra_Little said:
Hi, I was able to do a little more testing today, and found that if I set a schedule on the artifact in the release pipeline, then it will automatically run the stages defined if I leave the stages without a schedule. In other words, if I want the whole pipeline to run then I can put a schedule only on the artifact and I don't have to also put a schedule on the stage. I tested this by adding multiple schedules for one day, and that worked. It looks like it will work for multiple days per week but not enough time has passed to "prove" it. One note-- to get new changes to a branch to flow through, you will need a build to run to produce a new version of the build artifact to pass off to the release pipeline. Otherwise we will just be deploying the last artifact which is available for this pipeline. I'm guessing you might already have that covered but just mentioning it in case that's not rigged up yet. Cheers, Kendra
Thank you, Kendra, I was also successful with a schedule on the artifact. I guess I complicated it a bit by also setting a schedule on the release itself as well, but it worked as well. Thanks again.
/ comments
Kendra_Little said:
Hi,I was able to do a little more testing today, and found that if I set a schedule on the artifact in the release pipeline, then it will automatically run the stages defi...
Thank you Kendra, That might be it. I just set the schedule on the artifact here: [image] With these being the details of the schedule: [image] So my assumption is that a new release will be made daily at 5AM, and then a deployment is made daily at 6:30AM based on the screenshot in my previous post. I guess I thought I could keep making deployments from one release, but if this works then I'll be happy. I'll post my results tomorrow morning. Thanks again!
/ comments
Thank you Kendra,That might be it. I just set the schedule on the artifact here:With these being the details of the schedule:So my assumption is that a new release will be made daily at 5AM, and th...
How do I create a recurring schedule to deploy a release to our dev databases?
Hello All,We use DevOps and Change Automation to deploy releases to our different environments. We also have separate jobs that drop our development databases daily and recreates them. Because of t...