SQL server Agent job depedencies
$30-250 USD
Paid on delivery
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
Project ID: #18103854
About the project
15 freelancers are bidding on average $99 for this job
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
Hi we will schedule according to ur req and please let me know ur version of sql server and what is the frequency
Dear client, I am a rockstar MS SQL Server expert with over 10 years of experience in MS SQL Server, C#, ASP.NET. I know exactly what you need and I can get it done in 3 days. Let us talk further. about me: abou More
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.
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin More
I am having 4+ years in SQL server and job creation and handling or administrating them, I can complete the project as per the requirements.
Accomplished technical professional with 12+ years of experience in development and guiding team through all software development phases, from requirement gathering and analysis to design, development, testing, impleme More
Hi, I would like to do this project, I'm MS SQL Certified Developer with 6 years of experience in SQL Server 2016 and MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services More