Shell Script

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi All,

Requirement is:- Need to create on sh to run one sql query in database in every 20 mins and need to save the output each time in one file(not overwrite) with timestamp also means the time when the query runs.Please help /guide me to do the same.

Thanks
Shiv

---------- Post updated at 04:29 AM ---------- Previous update was at 04:02 AM ----------

Any help please

2

Next time, find a appropirate subject for the title...

We are not here to do the work for you, so what have you done so far, or where are you facing issues?

4

So, a few questions:-

  • What have you tried so far?
  • What errors or output are you getting?
  • What OS and version are you running?
  • What tools are you most comfortable with?
  • How do you plan to start the job?
  • How do you plan to connect to the database?
  • What logic have you considered?

Most importantly, What have you tried so far?

There are plenty of options, but you are not really giving us anything to go on.

Robin