Is the library that you are using assigned to the server used by the job in DIS ... View more

Yes and we had to re-build the job from scratch... raise with TS Barry ... View more

Without looking at your log - Do u have an index on the table? ... View more

If you have used DIS to create the job you can get it to create a status file/dataset (easy point and click), your other job can then check for that file and it's contents Barry ... View more

Try posting this in the Deployment group you may get a better response from there ... View more

That was the one I found but didn't want to give you the wrong informaion Helpful answer or answer on my response ... View more

I am sure this can be changed in registry but I wouldn't know where to start - I did google and there are lots of similar questions - as I said this is a Windows 7 issue not SAS, SAS used the login you provided, Windows then uses that as the last user logged in. ... View more

Ah so it didn't actually change your user id it changed the userid that is displayed in your login screen and you have to enter your actual one... I am sur ethere would be a windows policy that could change that as where we are (on windows 7) it is always blank and you always have to enter your userid and password... Search Google for 'Windows 7 default log in' I am sure the answer will be there for you - this is a windows 7 thing not SAS Barry ... View more

Not sure how a sas install would have changed your windows user name.... Also SAS should be installed on your machine so doesn't matter if you create a new user, SAS should be available to the new user also Barry ... View more

What version or portal/SAS etc are you using... As Data explorations were removed in 9.2 ... View more

re reading your question " sas eg is working great with metadata server and all but i wants to conenct sas base (Foundation 9.3) to metadata server"  your base sas needs to know about the metadata server etc, You'll need something like /* Create metadata macro variables */ %let metaPort       = %nrquote(8561); %let metaServer     = %nrquote(servername); /* Set metadata options */ options metaport       = &metaPort         metaserver     = "&metaServer"; Then you can do a libname using libname libref META library = ....; Barry ... View more

because on your local machine d: is probably defined as something else, try using UNC ir \\servername\d$ or something like that... also why do you want to access a server library from local? ... View more