Thank you very much. now its working after changing the options in the batch server ... View more

Main purpose of my code is to send the mail alerts when there is an error in the code. here is the error "Libref SBA is not assigned" so it should send the mail and then abort the program. but it is not sending the mail where as the statement that placed after mail statement "abort cancel" statement is executed , even though the statement is in the same macro as mail statement ... View more

Following is the log when i run the program through Batch server   /* Macro to abort code at that particular step in case of an error and send to the Error*/ 64 65 %macro ab_stop; 66 /* &syserr is a default macro variable which is generated internally in SAS */ 67 %if not (&syserr eq 0 or &syserr eq 4) %then %do; 68 FILENAME Mailbox EMAIL TO=('XXX@YYY.com') 71 CC=('xxxx@yyy.com' 72 'xxx@yyy.com') 73 Subject='JOB FAILURE!!!'; 74 DATA _NULL_; 75 FILE Mailbox; 4 The SAS System 10:00 Monday, October 31, 2016 76 PUT "job failed due to following error"; 77 PUT "&SYSERRORTEXT"; 78 RUN; 79 %abort cancel; 80 %end; 81 %mend; 82 proc sql; create table temp1 as select * from sba.cars; quit; ERROR:Libref SBA is not assigned.     NOTE: The SAS System stopped processing this step because of errors. NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set. NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2016-10-31T11:05:00,601-04:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 4529429| _DISARM| 14323712| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 40190216| _DISARM| 0.000000| _DISARM| 0.000460| _DISARM| 1793545500.601018| _DISARM| 1793545500.601478| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-10-31T11:05:00,601-04:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 19574784| _DISARM| 14323712| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 40190216| _DISARM| 0.000000| _DISARM| 0.001256| _DISARM| 1793545500.600375| _DISARM| 1793545500.601631| _DISARM| 0.000000| _DISARM| | _ENDDISARM 176 %ab_stop;   NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2016-10-31T11:05:00,604-04:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 19574784| _DISARM| 14323712| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 40190216| _DISARM| 0.000000| _DISARM| 0.002365| _DISARM| 1793545500.602433| _DISARM| 1793545500.604798| _DISARM| 0.000000| _DISARM| | _ENDDISARM NOTE: PROCEDURE SQL used ( (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: Execution canceled by an %ABORT CANCEL statement. NOTE: The SAS System stopped processing due to receiving a CANCEL request.   ... View more

the Current environment doesn't have SAS scheduler license so we are using OS scheduler which don't have capability to send mail alerts ... View more