topic Re: Killing RSUBMIT Process in New SAS User

Killing RSUBMIT Process

tiramisu — Tue, 12 Jan 2021 15:41:17 GMT

I run a simple query like the following:

rsubmit;
proc sql;
create table x.txn_filtered as
select *
from y.txn_all
where ID = 123
;
quit;
endrsubmit;

But all I keep seeing is the below log; and I am unable to run anything else, as when I run "quit", I get an error message "A PROC is currently executing..."

30 rsubmit;
NOTE: Remote submit to EDW603 commencing.

Given this:

1. Why is the code not being processed? Is it a server performance issue?

2. How would I kill/abort/stop/quit this remote submit process?

3. How can I see all of the rsubmit processes that I am running?

Thank you!

Re: Killing RSUBMIT Process

PhilC — Wed, 13 Jan 2021 13:07:38 GMT

Given this:

Based on what I know, and I use RSUBMITs with SAS CONNECT, set up on Windows:

1. Why is the code not being processed? Is it a server performance issue?

Perhaps. Perhaps someone else, or others, are running something. Perhaps its something else. Your server admin might need to get involved. Your recent sessions could have become runaway processes.

2. How would I kill/abort/stop/quit this remote submit process?

One couldn't kill something they were running remotely unless they has login access to the remote server. If you contact your IT person that has access you can provide the Process ID's that you believe are your runaway processes. Then those proceess could be identified and killed.

3. How can I see all of the rsubmit processes that I am running?

I don't know how to answer that exactly, but you can look on the shared drives that the server has open to see the files in your work directory on the server. In fact if your dealing with runaway processes you'd be able to see the folders that are named, for example "_TD7152_XYZ_" where XYZ is the server, 7152 is the process ID. Your file system should be able to inform you that your account owns these folders. This may give you the information you are looking for, i.e. the "sight" to see all of you currently running RSUBMIT processes.

Re: Killing RSUBMIT Process

tiramisu — Wed, 13 Jan 2021 03:06:27 GMT

Ah okay, so are there no queries I can run to check and terminate the runaway processes that were initiated by me?

Re: Killing RSUBMIT Process

PhilC — Wed, 13 Jan 2021 13:13:41 GMT

None that are queries created by SAS for SAS/CONNECT users, that I am aware of. If there are, I'd love to know about them.