Thanks David, there are couple points here which we need to double check.

--- "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV> wrote:

> Jeff Morison <jmt_mtf@yahoo.com> wrote: > > When I schedule a SAS job to run at a specified > time > > through Windows 2000 Scheduler the job runs but it > > freezes my machine, I have to shut down and > reboot, > > but the SAS Log looks everything OK. > > > > This SAS Job, accesses data from TERADATA and > creates > > some summary statistics. > > > > Has anyone had this freezing problem?, can any > suggest > > how to handle this?. > > I haven't seen this freezing problem before, and I'm > certainly > not a TeraData expert. But I can make some > suggestions, > some of which you've probably already checked out. > > [1] Is this a Win Scheduler problem? Have you tried > this > with another scheduler? Have you tried it with no > scheduler > at all (just submitting it at close of day as you > leave the > office)? Does it still freeze up? > > [2] You say that you get all the SAS log. Does it > also show > the time stats for the entire program? If not, then > it is > probably aborting before the SAS job gets finished. > If so, > then it may be a network connection problem. Can > you check > whether the network connection to the TeraData > server was > properly closed? Or can you set up the scheduler so > that > the SAS job wraps up shortly after you get in > tomorrow morning, > so you can watch for error messages or network > problems (say, use > your Control Panel to put up a Performance meter and > watch > for network traffic)? > > [3] Can you talk with your TeraData sysadmin and > find out if > he/she has anything set up which might be causing > these problems? > > It seems like there are a lot of potential sources > for this > problem, so I think you're going to be doing a lot > of checking > in the near future... > > Sorry I can't be more helpful, > David > -- > David Cassell, CSC > Cassell.David@epa.gov > Senior computing specialist > mathematical statistician >

__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com