The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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