Custom SQL Script
$30-250 USD
Paid on delivery
Need a custom SQL script built. The script will do 4 things. 1 - detect blocking processes; 2 - Kill the SPID running the process; 3 - run a select statement to find a value; 4 - use that value to run an update statement. The script will be run as a job and running every 5 or 10 minutes.
Project ID: #18206464
About the project
13 freelancers are bidding on average $230 for this job
Hello, As an expert in ms sql server, i am very much interested to do this project. I understand what you need. Looking forward to have a positive response from you. Thanks
Hello Sir, I have build a similar SQL Job in past to perform these steps and would like to work with you on this project as well. Thanks Aanvik
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, database management, More
Hello, how are you? I am a talented developer with good skills I've just read your project descryptioin and i am interested in it I can complete your project in your timeline perfectly I am expert in MySQL, MSSQL I More
Hi, I am 12+ years experienced Database Administrator at CMMI-5 level company. I have 20 member team of different Technology. We are working on : RDBMS :Oracle,MySQL,PostgreSQL, MSSQL Server 7.0/2000/2008R2 and Onw More
Hello There! We are an IT freelancers group with more than 15 years of experience with MSSQL. We can help you create this script and also we can provide several other scripts for automating tasks. Trust in u More
Hello, I can help you. I have more than 10 years of experience in SQL Server administration and querying. Thanks, regards.
I have wide experience including but not limited to the required ones.. I am SQL Expert with more than 10 years of hands on experience .. I will make sure to deliver the project successfully
Hi. This is not solution to kill blocked queries. Also SQL Server detects deadlock for self and kill automatically such processes. Please clarify what did you mean when write "block" maybe I think about something diff More
hi i already create script in sql for deadlock finding process. i will create agent for u that run for every 5 min.
Microsoft certified SQL proffessional with 4yrs of experience. Excellent in performance tuning