I need to create SQl job dependeicies.
Lets say that I have JOB A which is dependent of JOB B
I need a SQL code to run as first step in job A, which will check the status of JOB B as:
1. if job B was finished successfully then start go to second step (meaning continue executing job A with successful execution of step 1)
2. If job B is running still then send email that JOB B is still running and Add delay of 10 minutes and after that again check status. This is should be a loop 3 times. After 3rd iteration of loop if JOB B is still running then fail job A with error that JOB B is still running
3. if JOB B ran and failed execution then fail JOB A and error out that JOB B was failed earlier
4. if JOB B was cancelled by a user then fail JOB A and error out that JOB B was cancelled
IT should be a procedure that takes job name as parameter (JOB B) and do all those thing. Kind of portable procedure that can be a step 1 to any other job and provide depedencies
18 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě $115
hi, i am sql/ c# developer written many store procedure, sql jobs/ scheduler, function, etc... written many queries for fortune companies and received appreciation from clients
I am working with SQL Server for more than 15 years in an MNC. If I get a chance I can assure you I will provide you the best solution,according the logic you provided in the description. skype ID is:[login to view URL]
Hi, I work as business intelligence developer. I can write the stored procedure according to your mentioned requirement. I am confident that I can deliver this task.
1. 10 Years of experience 2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report 3. Worked in almost 150 projects. 4. Dedication,timely execution and perfection is my key Skill.