Find Jobs
Hire Freelancers

quick vbs or powershell script to query Sybase DB and mail

$30-250 USD

Closed
Posted almost 4 years ago

$30-250 USD

Paid on delivery
I would like to add a script to Windows scheduled task to run every 15 minutes which should perform the following: - Log each action to a log file - Run a query against Sybase DB. Select statement that looks at the 15 most recent rows for a specific value in a column. If the field in the table has a specific value for last 15 times in a row, then something is wrong and send a mail via smtprelay. - if that value is not found in the most recent 15 rows during the last 15 minutes, then log and exit. There is a date and time combined field that should be used to look up if the most recent rows have that specific value. I am flexible with the script if you have better ideas. But please ask as many questions up front as this is due right away. This script can be written in vbs or powershell. I started on this so I have somewhat of a half done script. Thank you.
Project ID: 26240724

About the project

11 proposals
Remote project
Active 4 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
11 freelancers are bidding on average $137 USD for this job
User Avatar
I am good in powershell, vbscript, database along with automation and development, please let me know if you are good to award this project to me
$150 USD in 3 days
5.0 (49 reviews)
5.6
5.6
User Avatar
Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards.
$250 USD in 7 days
5.0 (8 reviews)
4.2
4.2
User Avatar
Hey There, Greeting for the day... Could you please have quick discussion. I am Microsoft Certified Engineer. I have 12+ years of experience on Windows Server Administration 2003/2008/2012/2016/2019 and it's almost all features i.e. AD, DNS, DHCP,IIS,DFS,Certificate Authority, ADFS and AD migration and upgrade. Also I have hands-on experience on Powershell GUI and non GUI Scripting. for more details please have look at my portfolio. I have previously carried out a number of projects like the same. Kindly contact me to move further SachinP
$140 USD in 7 days
5.0 (10 reviews)
3.5
3.5
User Avatar
Hi. I have written many automation PowerShell scripts also VBScripts. Ready to write your project. Will complete within 3 days
$120 USD in 3 days
5.0 (5 reviews)
3.1
3.1
User Avatar
I am working as Powershell developer from last 6 Years. Check my related to DB. Please connect to work further on same.
$150 USD in 2 days
5.0 (2 reviews)
2.8
2.8
User Avatar
Hi, I work doing automations with powershell. I would like to participate in your project. please send me to chat to share details. Relevant Skills and Experience Hi, I work doing automations with powershell. I would like to participate in your project. please send me to chat to share details.
$111 USD in 3 days
5.0 (3 reviews)
2.5
2.5
User Avatar
Hi Client , I already done similar project, I can close this task immediately. I’m an Independent, Senior Software Developer & Freelance Web & Automation developer with 5+ years of experiences with Master degree holder and expertise in PYTHON, PHP, HTML 5, CSS3, JAVASCRIPT, NODE. JS, MYSQL, MONGODB, POWERSHELL technology with complete Full stack web developer and automation scripting developer. I’m a huge fan of the work, my goal is to get the project done on time with client satisfaction. If you have the time, I’d like to chat with you about the job requirements of yours. If you have time to talk, you can reach me anytime Thanks for your time, and I look forward to hearing from you.
$30 USD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
Hi, Powershell is perfectly fine for this requirement. It can be used for quering sybase db, check and email. It can also be scheduled with windows task scheuler. I am available to complete script for you. I can complete script within couple of hours. I am available right away to start. To start working, I will need the details of sybase connection and smtp settings. Thanks
$55 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Hi, We can create a VBScript to connect to the Sybase DB. Post that we can use the script to fetch the rows and record the columns. The script works as below 1. Check the current time stamp from the system. 2. Connect to the database. 3. Fetch the 1st 15 rows and the required column based on timestamp. 4. Search the specific value in the column. If found will trigger mail. 5. If not found, will create log file in the requested location and exit. Timeline: 1. Gather requirement :- 1 day 2. Create Script :- 2 days 3. Testing need to be performed by User. - 1 day
$120 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Llevo más de tres años trabajando en automatizaciónes ppwershell
$156 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Saint Joseph, United States
5.0
4
Payment method verified
Member since Sep 11, 2018

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.