Find Jobs
Hire Freelancers

quick vbs or powershell script to query Sybase DB and mail

$30-250 USD

已关闭
已发布将近 4 年前

$30-250 USD

货到付款
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.
项目 ID: 26240724

关于此项目

11提案
远程项目
活跃4 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
11威客以平均价$137 USD来参与此工作竞价
用户头像
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 在3天之内
5.0 (49条评论)
5.6
5.6
用户头像
Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards.
$250 USD 在7天之内
5.0 (8条评论)
4.2
4.2
用户头像
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 在7天之内
5.0 (10条评论)
3.5
3.5
用户头像
Hi. I have written many automation PowerShell scripts also VBScripts. Ready to write your project. Will complete within 3 days
$120 USD 在3天之内
5.0 (5条评论)
3.1
3.1
用户头像
I am working as Powershell developer from last 6 Years. Check my related to DB. Please connect to work further on same.
$150 USD 在2天之内
5.0 (2条评论)
2.8
2.8
用户头像
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 在3天之内
5.0 (3条评论)
2.5
2.5
用户头像
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 在1天之内
5.0 (1条评论)
0.4
0.4
用户头像
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 在1天之内
0.0 (1条评论)
0.0
0.0
用户头像
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 在4天之内
0.0 (0条评论)
0.0
0.0
用户头像
Llevo más de tres años trabajando en automatizaciónes ppwershell
$156 USD 在3天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Saint Joseph, United States
5.0
4
付款方式已验证
会员自9月 11, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。