SQL server Agent job depedencies

$30-250 USD

Κλειστή

Αναρτήθηκε

πάνω από 5 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση

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

Microsoft SQL Server

MySQL

SQL

Ταυτότητα εργασίας: 18103854

Σχετικά με την εργασία

15 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

15 freelancers δίνουν μια μέση προσφορά $99 USD για αυτή τη δουλειά

@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

$35 USD σε 1 ημέρα

4,9

(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

$40 USD σε 1 ημέρα

4,8

(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: about me: I have more than 16 years of experience in software development, and for the last 10 years I have been doing web development using PHP, MySQL, ASP.NET MVC, MS SQL Server, HTML, CSS, JavaScript, jQuery and Angular

$200 USD σε 3 ημέρες

5,0

(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.

$55 USD σε 1 ημέρα

4,8

(2 αξιολογήσεις)

1,5

@Rightwayonline

$66 USD σε 1 ημέρα

0,0

(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 doing DB design. Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS

$155 USD σε 3 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@rohitsingh1576

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

$45 USD σε 3 ημέρες

0,0

(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 αξιολογήσεις)

0,0

@dhanrajpervaram

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

$133 USD σε 4 ημέρες

0,0

(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, implementation, and support. Leverage passion, computer management background and tenacious problem-solving capabilities to develop innovative database oriented, rich web application and report building solution. Development achievements include incorporating scrum methodology to strengthen test-driven development, validation and change management activity. TECHNICAL PROFILE Platform: Windows 2000, Windows XP, Vista 7, Server 2008 R2, 2012, Windows 10 Languages: ASP.NET, VB.NET, VB6.0, C#, .NET Framework 2.0/3.0/3.5/4.0 /4.5, WCF, XML, Java Script, jQuery, LINQ, MVC 5, Entity Framework 6.0. Database: MS SQL Server 2000/2005/2008 R2/2012, MS Access, SSIS, SSRS, SSAS, Cosmos DB (Document DB), Power BI Report Server. Source Control: Visual Source Safe, TFS 2010/2012/2013/2015, VSTS, GIT. Cloud Computing: Azure - Web/API Application deployment, Application Insights, Functions, Logic Apps, AAD, ML, DW, VM, BLOB, Table and Queues storage. AWS – EC2, S3, IAM, VPC, RDS. Tools: Visual Studio 2010, 2012, 2015, 2017, Visual Studio Business Intelligence Development Studio, Visio, DevExpress, Telerik, Fiddler, Fusion charts, Crystal Report, Report builder 2.0/3.0., EF, High charts, D3, Dimple, Power BI Desktop, Visual Studio Code.

$111 USD σε 4 ημέρες

0,0

(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 (SSIS), SQL Server Reporting Service (SSRS), PowerBI and SQL Server Analysis Services(SSAS)

$30 USD σε 1 ημέρα