Închis

SQL server Agent job depedencies

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

Aptitudini: Server Microsoft SQL, MySQL, SQL

Vezi mai multe: sql server 2005 job scripting sql, sql server agent icon visio, using bcp sql server agent, sql server job dependency, sql server agent job dashboard, sql job current execution status, sql server agent job best practices, sql agent job dependent on another job, sp_start_job wait for job to finish, sql server agent job manager, manage sql server agent jobs, sql server 2000 script sql server agent jobs, sql server agent bcp, script start sql server agent sql server 2000, sql server agent check file stored procedure, sql server script job, sql server agent job bcp, sql server 2000 sql server agent copy files, auto backup sql server 2008 job, sql server 2008 job setup backup

Despre angajator:
( 0 recenzii ) baroda, India

ID Proiect: #18103854

18 freelanceri licitează în medie 115$ pentru acest proiect

sreenivas2903

Hi we will schedule according to ur req and please let me know ur version of sql server and what is the frequency

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(13 recenzii)
4.0
laminarbytes

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(3 recenzii)
1.6
ibrahim20

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

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
0.6
lucasdalto

Hello! My name is Lucas Dalto, I'm CEO of StreaSer ([login to view URL]) Online education platform that was among the TOP Best 15 In Argentina #potenciate. I was in companies like Huawei, Lenovo, Cisco, PayPal, Goog Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 10 zile
(0 recenzii)
0.0
amarkumardz

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
i4ConsultantDev

Hi, I am interested in your project and I would like to know more details. Kindly drop a message so we can [login to view URL] 6+ Years I've been working on and around Database Design, Development & Support of MS SQL Server Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
krishnabims

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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
droyrg

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]

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)
0.0
SachinEdge

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(0 recenzii)
0.0
dhanrajpervaram

Certified Microsoft sql server professional. Excel in SqL server and SSIS

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(0 recenzii)
0.0
sunilmudunuri

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
rohitsingh1576

Thanks Relevant Skills and Experience Have 6 years of experience in SQL server

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
keataun17

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.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
bbbssolutions

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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(0 recenzii)
0.0
%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
evonsystems7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(0 recenzii)
0.0
simpliumgroup

Hello, I have more than 10 years of experience in the industry within BI Space and Reporting Platform. I can get this work done in a few hours and am ready to answer any questions that you have. I have handled co Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0