Find Jobs
Hire Freelancers

Auto run view and save as CSV

$30-250 USD

Completed
Posted almost 9 years ago

$30-250 USD

Paid on delivery
I have a sql view. I need a job (or trigger?) to run this query at 8:00pm every week day and save the output to a specific folder. It should also count the number of records in the output. The saved file should be named "xxx" - "date" (mm-dd-yy) - "x" records
Project ID: 7456390

About the project

4 proposals
Remote project
Active 9 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
Awarded to:
User Avatar
Hello, I am very much interested to do this work as i have strong knowledge on working in sql server, i can create a sql job to fulfill your requirements. Looking forward to have a positive response from you. Thanks
$50 USD in 2 days
5.0 (180 reviews)
7.2
7.2
4 freelancers are bidding on average $59 USD for this job
User Avatar
Hello, I am employed SQL Server/Oracle developer, and I could make that job for you as I have done it before on SQL Server, I would like to hear which environment are you using? Oracle or SQL Server? In any case the process is similar so it wouldn't be a problem. If you are interested, feel free to contact me. In any case, thank you for the consideration and good luck with your task.
$66 USD in 3 days
5.0 (30 reviews)
7.4
7.4
User Avatar
What we can do is to make and SQL server scheduled job that will execute a view every day at specified time or the second option could be to make a small exe that fetches the stuff from sql view and we can run this exe from windows scheduler and can set the scheduled routine.
$60 USD in 3 days
5.0 (108 reviews)
6.6
6.6
User Avatar
Hi, can you give me some more information for me to ensure I have bid accurately? Is this a MySQL job or are you running some other type of SQL server? Is this Windows or Linux? I have bid based on MySQL and linux. I would do the script in php and add it to a cron job. Please let me know if this would work for you. Thank you Respectfully Risharde
$60 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Jersey City, United States
5.0
8
Payment method verified
Member since Feb 11, 2009

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.