Re: How can you automate SQR reports to run say at Month-End Usin g ma ybe the AT Windows command and how do you pass parameters to the rep ort.

["Shaver, Richard H" <richard.h.shaver@LMCO.COM>]

Greg,
I use WinAT to schedule batch jobs (.cmd in NT) to run when I need them to.
We are running on SQL Server, but the premise is the same. An example of the
statements are run are:

(NT Server drive):\(path)\sqrwt (NT Server drive):\path\file_name.sqt
database/userid/password parameters

to print the reports I use the following:

COPY (NT server drive):\(path)\file_name.lis  \\(printer server\printer_name

Below is the actual code I use (formatted for ease of reading - at least on
my screen.  The first line and the following indented lines are actually 1
line in the code):
d:\lm_data\88-24_data_systems\maximo\sqr_batch\sqrwt
  d:\lm_data\88-24_data_systems\maximo\sqr_batch\tx_wash_b.sqt
maxprod/sysadm/sysadm
  -ed:\lm_data\88-24_data_systems\maximo\sqr_batch\tx_wash_b.err
copy d:\lm_data\88-24_data_systems\maximo\sqr_batch\tx_wash_b.lis
\\thor-cw\MPW_Main_LJ

Good Luck
Rick


-----Original Message-----
From: Blodgett, Greg [mailto:Greg.Blodgett@PREMCORINC.COM]
Sent: Thursday, September 14, 2000 6:49 AM
To: SQR-USERS@list.iex.net
Subject: How can you automate SQR reports to run say at Month-End Using
ma ybe the AT Windows command and how do you pass parameters to the
report.


Visual SQRIBE 5.0 SQR Server 4.0.3
Windows NT 4.0 Service Pack 5
Oracle DB 7.3.2.2
PSDI Maximo 4.02
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper at Premcor. for the presence of computer viruses.
        Please contact administrator@premcorinc.com for information or
assistance.

www.mimesweeper.com
**********************************************************************