Closed

Create daily report through Stored Procedure save in local folder -- 2

I need a stored procedure which will do two things:

1) Pull column A, B, C from a table and save it in a M:\test drive daily

2) Pull column A, B, C from a table send it to three email ids in a table

format printed inside the email and not as a link inside email daily

3) Need a script that will run daily and check if there are any files which are

older than 6 months and delete those files from M:\test drive

Skills: Oracle, SQL

See more: procedure sql oracle, stored, create sql report, email oracle sql script, save report, test drive test, email daily report, daily report, sql create report, link oracle table, create daily report mysql, php create daily report mysql, script create table oracle, stored procedure create sql, oracle procedure, delete files folder, run local script, folder procedure, oracle create table, oracle script send email, create table script sql, oracle table create script, create table oracle, oracle create table script, email oracle

About the Employer:
( 0 reviews ) United States

Project ID: #5915566

25 freelancers are bidding on average $151 for this job

truongnguyen86

Hi there, im expert on oracle, pls share more about your requirements. Waiting for your feedback. Thank you

$200 USD in 3 days
(29 Reviews)
5.2
rinsadsl

Hi there I can do this job for you. I am quite handy with Oracle PLSQL and SQL. Looking forward to hear from you. Thanks Rinsad

$157 USD in 3 days
(26 Reviews)
5.0
prakashmondal

hi, I am interested to develop a windows scheduler driven application to do the job daily. I will use store procedure to retrieve data from database and store in to particular directory as per the requirement. Please More

$150 USD in 3 days
(8 Reviews)
4.5
Reza2012

Hi I have more than 10 years experience in Oracle database design, administration and PL/SQL programming. Please see my profile and share details with me. Thanks.

$155 USD in 3 days
(17 Reviews)
4.4
saykor

A proposal has not yet been provided

$210 USD in 3 days
(5 Reviews)
3.6
acronymsolutions

Hi, I have gone through your requirement.I am a DBA at CMM5 Level company since August 2010.I am working on SQL,Oracle database, I can do your job [url removed, login to view] revert me is there any concern.I am ready to start y More

$147 USD in 3 days
(7 Reviews)
3.6
sandipsngh1988

hello I m able to complete your task as I have experience about 3 years in .net with ssrs and sql server .

$111 USD in 3 days
(1 Review)
0.8
aniket0204

A proposal has not yet been provided

$150 USD in 3 days
(0 Reviews)
0.0
kozh1121

Hi, I know exactly how to do it. I did it before. E-mail will be sent in HTML format using SMTP protocol. I don't see any problem saving files to specified directory. Please give me a chance to complete my first projec More

$155 USD in 2 days
(0 Reviews)
0.0
ashishagrawal80

This is our almost daily exercise. we are doing the same thing in my company. We are basically works on Oracle Demantra Application which is Demand Forecasting [url removed, login to view] the source for demantra is sometimes a flat file More

$111 USD in 2 days
(0 Reviews)
0.0
augustinejoshua9

We are a efficient team working to build various projects and will successfully and efficiently complete your project as required

$111 USD in 6 days
(0 Reviews)
0.0
sudar05

A proposal has not yet been provided

$111 USD in 4 days
(0 Reviews)
0.0
yand

Hi! I can help you. Can you send me table structure? What version of Oracle you are running? Which OS you are using?

$155 USD in 3 days
(0 Reviews)
0.0
nikunjjhanwar87

Experience of above 5 years 8 months as Techno Functional Consultant in Oracle E business suit R12 and 11i; Worked as module lead for financial modules like Accounts payables, General ledger, Oracle Payments, E-busines More

$155 USD in 3 days
(0 Reviews)
0.0
mahmoudfcas

I have experience in SQL and ORACLE and skills that qualifying me to this role and I will finish your work on time

$133 USD in 2 days
(0 Reviews)
0.0
AsenAsenov

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
Subburaj01

I have 8 years of IT experience - currently in USA- will be able to complete this on 4 days. my # +1 408 818 0033 -Thank you

$177 USD in 3 days
(0 Reviews)
0.0
Viktoor

Advanced level of writing PL/SQL codes, with proven practice of two and a half year, also in a big telecommunication company.

$111 USD in 5 days
(0 Reviews)
0.0
ikhavins

Hi! I'm an Oracle and PL/SQL developer. I can write and implement such procedure. Let me reiterate what you are asking: 1. Select 3 columns from Oracle Table and save it in a file on "M" drive. It could saved in More

$222 USD in 3 days
(0 Reviews)
0.0
techroom

i have experience in this field and i work everyday developing all kinds of scripts in db,c,c#, perl, shell, PLSQL, etc i work in a bank and we do this daily. its soo easy to do can we start work please ? th More

$166 USD in 1 day
(0 Reviews)
0.0