sql-server-2012sql-agent-jobsql-agent
SQL Agent Job dependency between two Servers
I've two SQL Agent jobs in two different Servers (D01->preload & s01->dwload).
My requirement is to run dwload job in s01 only after preload job in D01 is successfully completed.
preload job runs at 1:00AM and finishes at 7:00AM.
As of now, I've scheduled dwload to run at 8:00AM to avoid conflicts and disable it manually if preload fails for some reason.
My question: How do I create dependency between dwload and preload as they belong to different servers.
Solution
You could create a linked server in one of the instances. Here are a couple of links on how to set that up.
Calling Linked Server In Query
Once you have the linked server set up, you could create one job for both of them. Preload would be step 1 of the job and dwload would be step 2.
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?