Em Andamento

New PLSQL job - to move files and create emails and SMS

I need a PLSQL program developing which will run on a scheduled basis polling a local (client) database for unprocessed records. Once records have been identified, these records need to be moved into separate database (server side) across an intermittent network (slow and prone to dropping out).

Each record which is 'moved' may have an associated file held on the client (referenced in a field on the record) which also needs to be moved to the server at the same time as the record.

Obviously, due to the intermittent nature of the network, full error handling needs to be built into the solution to make sure a FULL rollback occurs on partial transports and incomplete server side loads do not cause subsequent issues.

Once the records (and files) have successfully been transported to the server, SMS notifications need to be issued and Emails produced notifying individuals of the delivery.

SMS, email volumes are low per run of the process.

This is a priority piece of work and needs to be delivered within 1 week.

Error handling is very important, delivered code should be recoverable and identify ALL issues eg fileserver full etc etc.

I expect you to be a professional and build me a solution that will error handle ALL scenarios, not just some, or the ones I mention, I need ALL scenarios covered!!

DO NOT BID FOR THIS PROJECT IF YOU ARE UNABLE TO BUILD STRUCTURED ERROR HANDLING INTO THE SOLUTION!!

You will complete an NDA.

The payment will be broken into 3 and will be released based on where we are with a workable solution. Final payment delivered on successful UAT of your code.

Full func spec available once project commences.

Please give me experience of your PLSQL experience and how you plan to implement this solution.

If you reply 'Lets Start etc' you'll simply not get selected, so please put some effort into a response.

Thanks

Dan

Habilidades: Oracle

Ver mais: plsql move file, move files plsql, move file plsql, plsql email file, plsql file move, plsql job file, plsql move files, workable, side job, reply response, plsql or, plsql file handling, plsql code, payment handling, job complete, get new job, complete job, all covered, plsql job create, plsql job email, sms plsql, plsql sms, move file job, run plsql job, move email job file

Acerca do Empregador:
( 19 comentários ) Birmingham, United Kingdom

ID do Projeto: #601112

Premiar a:

andregur

Please,see PMB

$1200 USD em 10 dias
(3 Avaliações)
6.7

11 freelancers estão ofertando em média $1241 para este trabalho

migueldiab

We are two XPs that will be working to deliver this in the requested timeline. The idea is to have a deaemon/service running that will pool the client DB and identify the records, it will then copy them to a temporary Mais

$1250 USD in 7 dias
(0 Comentários)
0.0
Ganga3116

Would be developed by good experienced engineer and with greater fast. Could contact on 91-9160110212,91-9052494999 for any clarification. Payment terms could be agreed on mutual discussion. Mais

$1200 USD in 7 dias
(0 Comentários)
0.0
muhabbat

I am working in oracle since last 5 years

$750 USD in 7 dias
(0 Comentários)
0.0
Aviva

please look PMB.

$1500 USD in 15 dias
(0 Comentários)
0.0
softdeveloper9

Sir, Please review my PMB. Thanks.

$1500 USD in 15 dias
(0 Comentários)
0.0
srinigenie

Please view PMB for more details.

$1100 USD in 7 dias
(0 Comentários)
0.0
inavigator

we already done lots of project with PLSQL and have knowledge with the things that you are asking. Please check PMB

$1500 USD in 30 dias
(0 Comentários)
0.0
biztec

We are having experienced database programmer to handle your project. We can deliver it as per your expectation

$1000 USD in 10 dias
(0 Comentários)
0.0
skmalviya1979

PLease check the PMB

$1200 USD in 15 dias
(0 Comentários)
0.0
akbarnaqvi16

Hi, I have 8 years of experience working on Oracle database on multiple platforms. I have experience as Senior Oracle DBA/Developer and have worked on oracle tools like OWB, OID, Oracle Streams and AQ to name some. Mais

$1450 USD in 7 dias
(0 Comentários)
0.0