How to schedule a SQL query and export data in common folder from oracle using c# / vb?

Question

1.00/5 (1 vote)

See more:

, +

Dear Friends,

i have a task to schedule on monthly basis using sql script. I have tried my every chance , everything gone in vein. Please share your thoughts

to execute a 500 lines[select] query at every month , 1st day ,at 01:00 AM and also should export as excel format. I really appreciate if anyone suggest some thoughts..

Thanks
Jagadeesh

Posted 28-May-13 1:13am

Jagadeeshbhat

Add a Solution

Comments

Suvabrata Roy 28-May-13 7:54am

You can easily scheduled it by creating some exe or SQL Jobs but what exactly your concern?

Jagadeeshbhat 28-May-13 8:33am

Thanks for your thoughts. Actually i don't know how to create it as a exe file/SQL Jobs... I'm a fresher in my organisation . This is my first task.

Now ,I have only a txt file which contains above 500 lines of Sql query . Kindly suggest me some thoughts which should be efficient, reliable in production server.

4 solutions

Solution 3

i have two table Manifest and manifestconsignment i want to insert value both the table one time one manifest no many consignment no insert inmanifest consignment i am using transaction using gridview

example
manifest no-00001

consignmentno nos weight
123 25 56kg
234 20 85kg
. . .
. . .

how to insert any one help me

Posted 28-May-13 2:45am

tarun kumar sahu hs

Comments

Jagadeeshbhat 28-May-13 8:49am

Please use trigger concept.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

farogh haider · Accepted Answer · 2013-05-28T02:16:00

Solution 1

Hi,

Create a windows service with scheduler and send data via mail or save data in folder.

Posted 28-May-13 2:16am

farogh haider

Updated 28-May-13 2:17am

v2

Comments

Jagadeeshbhat 28-May-13 8:43am

Thanks .Please suggest some link for reference [using C#].

*Suvabrata Roy* · Accepted Answer · 2013-05-28T02:43:00

Solution 2

Hi,

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/dotnet/getstarted-c/getstarted_c_otn.htm[^]

http://windows.microsoft.com/en-in/windows7/schedule-a-task[^]

Posted 28-May-13 2:43am

Suvabrata Roy

Member77 · Accepted Answer · 2013-05-28T02:48:00

Solution 4

You can create a Job in Sql Server Agent in Sql Server. There you can put your sql script in job step and then create a schedule based on your requirement.

Posted 28-May-13 2:48am

Member77