176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Update SQL reporting script written in VBS
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Nov 19, 2010
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Nov 16, 2010
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

I have a VBS script that emails information based on SQL queries. It queries the database for information and Bookings (customer visits) on Resources (employees of the company). The VBS script runs the queries on a Windows 2003 server. The VBS script is started using Windows Task Scheduler.

I would like the following changes/enhancements:
a. Add ability on all queries to exclude certain Resources from being queried, and modify which Resources are excluded when needed.
b. Stop all queries reporting bookings scheduled on Saturday and Sunday.
c. Add ability to independently stop certain queries in the VBS script from being run.
d. On the "Availability" query, add the following: If the Resource has Booking Type "Not in Office", it should also appear in the "Engineers Unavailable/Busy" line.

I can supply export of SQL database and access to the server using TeamViewer (this will be monitored though for security!)

Sign in or Register to see more

Desired Skills
Visual Basic, SQL
Job ID: 21943591
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Australia  |  
Winner
Reliable and experienced software engineer based in Australia with over 10 years of commercial software development experience in various...
3
  |  
 4.9   |  Private   |  1 Jobs
Bid ID: 21949263  |  Submitted: Nov 17, 2010 04:18 ET 
Delivery
Within 2 weeks
$200.00

 India  |  
Athena eSolutions is a company run by software professionals for professional clients like you.It is a highly motivated team which provides world...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 21944080  |  Submitted: Nov 16, 2010 17:49 ET 
Proposal SEALED

 India  |  
I specialize in .Net, web design and front-end development using XHTML, HTML5, CSS2, CSS3 and Javascript (jQuery library). I've been developing...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 21943960  |  Submitted: Nov 16, 2010 17:33 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »