SQL server Agent job depedencies

已关闭 已发布的 5 年前 货到付款
已关闭 货到付款

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

微软 SQL 服务器 MySQL SQL

项目ID: #18103854

关于项目

15个方案 远程项目 活跃的5 年前

有15名威客正在参与此工作的竞标,均价$99/小时

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

$35USD 在1天里
(13条评论)
4.6
sreenivas2903

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

$40USD 在1天里
(22条评论)
4.6
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 更多

$200 USD 在3天内
(3条评论)
1.6
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.

$55USD 在1天里
(2条评论)
1.5
$66USD 在1天里
(0条评论)
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 更多

$155 USD 在3天内
(0条评论)
0.0
rohitsingh1576

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

$45 USD 在3天内
(0条评论)
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.

$155 USD 在3天内
(0条评论)
0.0
dhanrajpervaram

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

$133 USD 在4天内
(0条评论)
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 更多

$111 USD 在4天内
(0条评论)
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 更多

$30USD 在1天里
(0条评论)
0.0