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.
Ταυτότητα εργασίας: 26240724

Σχετικά με την εργασία

11 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 4 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
11 freelancers δίνουν μια μέση προσφορά $137 USD για αυτή τη δουλειά
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 σε 3 ημέρες
5,0 (49 αξιολογήσεις)
5,6
5,6
Avatar Χρήστη
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
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 σε 7 ημέρες
5,0 (10 αξιολογήσεις)
3,5
3,5
Avatar Χρήστη
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
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 σε 2 ημέρες
5,0 (2 αξιολογήσεις)
2,8
2,8
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 σε 3 ημέρες
5,0 (3 αξιολογήσεις)
2,5
2,5
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 σε 1 ημέρα
5,0 (1 αξιολόγηση)
0,4
0,4
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 σε 1 ημέρα
0,0 (1 αξιολόγηση)
0,0
0,0
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 σε 4 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
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
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Σεπ 11, 2018

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.