RE: [sqr-users] SQR return-status

["Kaithi, Murali" <Murali.Kaithi@spencergifts.com>]

Thanks Don for replying.
I have tried your resolution before I posted this problem.
My program is stopped quitely but the scheduler is still showing completed with 
OK status.
Any Ideas please.

Thanks,
Muralidhar R Kaithi
Sr. Tech Specialist, PeopleSoft
(609) 645-5524
murali.kaithi@spencergifts.com


-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org]On
Behalf Of Don Mellen
Sent: Tuesday, August 31, 2004 12:08 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] SQR return-status


Before issuing the STOP QUIET, set the reserved variable "#return-status"
to the value you want for the error, I ussually start my "internal" errors
at 101 and go up from there (if you want specific error codes and to
have them separate from OS error codes).  Just to set an error you can...

   move 101 to #return-status

HTH,
Don

On Tue, 31 Aug 2004, Kaithi, Murali wrote:

> Let me explain my situation here.
> we scheduled lot of SQR jobs thru Arcana scheduler. The scheduler just runs 
>the Batch file in which all the SQR flags are set.
> I have used -XCB flag for the purpose that I shouldn't get any windows on the 
>server where these jobs are run.
> I want to get an email when any job fails and there is a parameter in the 
>scheduler saying that if the job fails it will automatically sends an email.
> My problem is even if the job fails for any reason the scheduler is showing 
>as the job is completed OK because of the fact that the SQR is not passing the 
>right #return-status to the operating system (in this case the Arcana 
>Scheduler).
> In my SQR program I am saying STOP QUIET if I want the job to stop instead of 
>using just STOP because of the fact that I don't want any window popping up on 
>the server saying "Program stopped by user request."
> To put it simple, I want the program to pass the error return-status to the 
>scheduler whenever I am stopping the SQR for any reason.
> Could anybody please help me on this.
> 
> 
> Thanks,
> Murali
> 
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users