Find Jobs
Hire Freelancers

quick vbs or powershell script to query Sybase DB and mail

$30-250 USD

Fechado
Publicado há quase 4 anos

$30-250 USD

Pago na entrega
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 do Projeto: 26240724

Sobre o projeto

11 propostas
Projeto remoto
Ativo há 4 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
11 freelancers estão ofertando em média $137 USD for esse trabalho
Avatar do Usuário
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 em 3 dias
5,0 (49 avaliações)
5,6
5,6
Avatar do Usuário
Hey there, I'm a Systems Engineer with coding skills. I had developed tons of PowerShell scripts. I can help. Regards.
$250 USD em 7 dias
5,0 (8 avaliações)
4,2
4,2
Avatar do Usuário
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 em 7 dias
5,0 (10 avaliações)
3,5
3,5
Avatar do Usuário
Hi. I have written many automation PowerShell scripts also VBScripts. Ready to write your project. Will complete within 3 days
$120 USD em 3 dias
5,0 (5 avaliações)
3,1
3,1
Avatar do Usuário
I am working as Powershell developer from last 6 Years. Check my related to DB. Please connect to work further on same.
$150 USD em 2 dias
5,0 (2 avaliações)
2,8
2,8
Avatar do Usuário
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 em 3 dias
5,0 (3 avaliações)
2,5
2,5
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
0,4
0,4
Avatar do Usuário
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 em 1 dia
0,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
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 em 4 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Llevo más de tres años trabajando en automatizaciónes ppwershell
$156 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Saint Joseph, United States
5,0
4
Método de pagamento verificado
Membro desde set. 11, 2018

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.