SQLTeam.com | Weblogs | Forums

Create a trigger file after a sql job completion


#1

I have a scenario where I have to create a trigger file to release all the ETL jobs after a cube job is completed in the sql server. Please help me with the steps on how can I create trigger file in sql server after a cube job is completed.
Thanks in advance


#2

There is no such thing as a "trigger file". What you need to do is set up job dependencies. So, as the first step in a job, it looks to see if its predecessors completed successfully. If not, the step throws an error. Then you can set up the step to auto-retry after some interval.