Find Jobs
Hire Freelancers

C#/MS SQL database monitor

$30-100 USD

Completed
Posted almost 18 years ago

$30-100 USD

Paid on delivery
I have a MS SQL Server 2k DB where a particular table is updated periodically (up to every 30 or so seconds). The table size is usually fairly small (<100 records). I need c# code that will run constantly to: 1) run a query on the table to determine if any records meet selection criteria (where a particular field is not found in a column of another table - this can be done either as a left outer join/null, a select where not in, or just using a view as a shortcut). This is easy, but I include it to be complete. 2) take each record and create a fax to a fixed number. This would ideally be done using the available XP COM, but any way of getting it out would work. 3) update a field within each record with a specified new value (i.e. the Status column is updated to "acknowledged" for each record). 4) Repeat the cycle every 30 seconds. I will fill in the actual table/column values, as they may change but are easily modified within the source. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows 2000 or XP MS SQL Server 2000 C#
Project ID: 3678896

About the project

18 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$25.50 USD in 7 days
4.1 (5 reviews)
2.0
2.0
18 freelancers are bidding on average $63 USD for this job
User Avatar
See private message.
$51 USD in 7 days
4.9 (110 reviews)
7.0
7.0
User Avatar
See private message.
$25.50 USD in 7 days
4.9 (112 reviews)
6.1
6.1
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (95 reviews)
5.9
5.9
User Avatar
See private message.
$34 USD in 7 days
5.0 (31 reviews)
5.3
5.3
User Avatar
See private message.
$85 USD in 7 days
5.0 (25 reviews)
4.5
4.5
User Avatar
See private message.
$63.75 USD in 7 days
5.0 (18 reviews)
4.4
4.4
User Avatar
See private message.
$76.50 USD in 7 days
5.0 (33 reviews)
4.4
4.4
User Avatar
See private message.
$170 USD in 7 days
4.3 (8 reviews)
4.2
4.2
User Avatar
See private message.
$42.50 USD in 7 days
5.0 (13 reviews)
3.7
3.7
User Avatar
See private message.
$85 USD in 7 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$63.75 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$68 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$76.50 USD in 7 days
0.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$24.65 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$68 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
1
Member since Jul 28, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.