[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: How to process SQR report on Unix
- Subject: Re: How to process SQR report on Unix
- From: "jayateerth.rp" <jayateerth.rp@MPHASIS.COM>
- Date: Tue, 14 May 2002 10:43:33 +0530
- Thread-index: AcH6qZnEV/r1TuF1RmSAs+Z+SodsmAAWnwhg
- Thread-topic: Re: How to process SQR report on Unix
Hi Kirthi,
Please find the answers against your questions.
-----Original Message-----
From: kirthi ajad [mailto:mymvs999@YAHOO.COM]
Sent: Monday, May 13, 2002 11:40 PM
To: SQR-USERS@list.iex.net
Subject: Re: How to process SQR report on Unix
Thank you very much jaiteerth and I have a small doubt here
1. azapx010.sh 020.sh---- is this the our shell script file name
Jay: Yes you are right. It's our script file.
2.How to set up particular timings to run a report on unix.(EX: hourly,
weekly,
mthly including date and time). I hope this has to be setup in our shell
script
is't it? if you send any information regarding this it would be great
help to
me as I am very new to unix and shell script as well.
Jay: For this you have to read little bit about shell script. But time
being you make use of the following.
Once your shell script is ready, you can schedule it using Cron daemon.
If you use "man cron" on your Unix system, you will get more info on the
usage of this. But please ensure the appropriate privileges to access
this scheduler.
Details are as follows.
#minute (0-59),
#| hour (0-23),
#| | day of the month (1-31),
#| | | month of the year (1-12),
#| | | | day of the week (0-6 with 0=Sunday).
#| | | | | commands
0 2 * * 0,4 Your file name including path
Regards,
Jayateerth
Date: Mon, 13 May 2002 10:26:40 +0530
From: "jayateerth.rp"
Subject: Re: How to process SQR report on Unix
This is a multi-part message in MIME format.
------_=_NextPart_001_01C1FA3A.91955B3A
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Kirthi,
Please find the attached Unix script & modify as per your needs.
Regards,
Jaiteerth
-----Original Message-----
From: kirthi ajad [mailto:mymvs999@YAHOO.COM]
Sent: Sunday, May 12, 2002 1:18 AM
To: SQR-USERS@list.iex.net
Subject: How to process SQR report on Unix
Hi All,
I am new to SQR and I just finished report using SQR with Sybase
Database (SQR 6.2(using Brio Report Builder) ,Sybase 11.2)and I wanted
to know how to run this report on unix. i.e what type of script i have
to be written and what are the steps needs to be follwed inorder to
process SQR report?
if any one is having script to do this it would be more help to me.
Thanks in advance
Siva
---------------------------------
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience