Custom SQL Script

In Progress Posted 5 years ago Paid on delivery
In Progress 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.

Database Administration Microsoft SQL Server Powershell SQL T-SQL (Transact Structures Query Language)

Project ID: #18206464

About the project

13 proposals Remote project Active 5 years ago

13 freelancers are bidding on average $230 for this job

sumon355

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

$90 USD in 2 days
(311 Reviews)
8.0
aanvikm

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

$155 USD in 3 days
(52 Reviews)
6.9
SergioAlfaroV

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

$120 USD in 1 day
(25 Reviews)
6.0
zekovicm

Hi there,I am Miljan,SQL expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agree More

$159 USD in 3 days
(4 Reviews)
5.2
masterlancer999

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

$155 USD in 3 days
(6 Reviews)
4.9
acronymsolutions

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

$50 USD in 2 days
(36 Reviews)
5.6
IntrinsecoTImx

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

$250 USD in 3 days
(2 Reviews)
3.8
germancasais

Hello, I can help you. I have more than 10 years of experience in SQL Server administration and querying. Thanks, regards.

$90 USD in 3 days
(3 Reviews)
3.7
NehadSalem

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

$155 USD in 2 days
(1 Review)
2.1
Asteroidishe

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

$1555 USD in 10 days
(5 Reviews)
1.4
jaysinhIT

hi i already create script in sql for deadlock finding process. i will create agent for u that run for every 5 min.

$45 USD in 3 days
(0 Reviews)
0.0
dhanrajpervaram

Microsoft certified SQL proffessional with 4yrs of experience. Excellent in performance tuning

$111 USD in 2 days
(0 Reviews)
0.0