Execute a proiv function as cron
Started by
Guest_David Taugher_*
, May 16 2002 04:50 PM
19 replies to this topic
#1 Guest_David Taugher_*
Posted 16 May 2002 - 04:50 PM
Hi All,
Is it possible to execute proiv via unix on a schedule? Although on the top of my head this is not possible, but who knows? Because we have a proiv report that we want to run on a daily basis by itself. And we are hoping that writing a sql script version isn't the only option.
Thanks in advance!
Dave
Is it possible to execute proiv via unix on a schedule? Although on the top of my head this is not possible, but who knows? Because we have a proiv report that we want to run on a daily basis by itself. And we are hoping that writing a sql script version isn't the only option.
Thanks in advance!
Dave
#2
Posted 16 May 2002 - 05:05 PM
There are several ways to do this. How you do it depends on the data that needs to be passed into the report function: if static, it is quite easy. If it needs to change, i.e., date ranges, it gets more complicated, but is certainly doable.
Describe the type of report and parameters needed to run it.
Describe the type of report and parameters needed to run it.
#3 Guest_David Taugher_*
Posted 16 May 2002 - 05:30 PM
Hi Rick,
The parameters being passed are:
CCN = '1' (STATIC)
SALES_CCN = '1'(STATIC)
FROM_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
TO_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
FROM_DATE = ALWAYS THE FIRST DAY OF THE CURRENT MONTH
TO_DATE = CURRENT DATE
OK CONFIRMATION
Thanks for the quick response! I appreciate it.
Dave
The parameters being passed are:
CCN = '1' (STATIC)
SALES_CCN = '1'(STATIC)
FROM_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
TO_GROUP = ''(BLANK AS DEFAULT - CAN BE STATIC)
FROM_DATE = ALWAYS THE FIRST DAY OF THE CURRENT MONTH
TO_DATE = CURRENT DATE
OK CONFIRMATION
Thanks for the quick response! I appreciate it.
Dave
#4 Guest_Joseph V.G. Orendain_*
Posted 16 May 2002 - 08:13 PM
what you can do is use the XFER command to transfer these parameters to your report. First of, you need to create an operator that allows transparent login and then attach your function in the logon link of the operator. Make sure to set the @LFUNCT of the last function to be executed to 'OFF' so it exits normally. Other option is, you can use an existing operator ID that has accessed to the report and then feed in the keystrokes that you will do just like doing it online....
sample script for the second type will be :
PRO SYS MDC > logfile <<- !
...specify here the steps you're gonna do...eg. set printer, call report function and then enter data,etc
!
exit
Hope this helps.
Joseph
sample script for the second type will be :
PRO SYS MDC > logfile <<- !
...specify here the steps you're gonna do...eg. set printer, call report function and then enter data,etc
!
exit
Hope this helps.
Joseph
#14 Guest_David Taugher_*
Posted 03 June 2002 - 02:37 PM
Thanks Bryan! I didn't want to set my PROTERM to anything before because it might have effect globally to all users. But now I tried it and it did work with DECVT100.
There is another problem though in setting the font when I use the 'mailx -s' in unix. Is there a way I can set the font to say 'courier new' before mailing?
Dave
There is another problem though in setting the font when I use the 'mailx -s' in unix. Is there a way I can set the font to say 'courier new' before mailing?
Dave
#15
Posted 03 June 2002 - 03:42 PM
I don't know of any way to do that in mailx.. If its important than I would probably create the mail as an html page and change the fonts in there. Its probably the long way around, I would imagine that there is a way to change the fonts for mailx but I couldn't tell you what that is off the top of my head...
Bryan
Bryan
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users