RE: [sqr-users] Schedule a SQR and send the email...When error occurs...

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

I don't have sample code because I've never done this particular task, but
you could write an sqr program that runs continuously, and reads the
PSPRCSRQST table once every 10 seconds, looking for processes with the
runstatus = error.

You may have to wait a while before the log file is posted, but you should
know the path if you know the process instance number.

For the last step, sending an e-mail with an attachment, I'll refer you to
the SQR discussion list archives.



-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of senthilkumar periyasami
Sent: Wednesday, February 21, 2007 1:33 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Schedule a SQR and send the email...When error
occurs...

Scenario :
 
I'd like to schedule and email a sqr when there is the errors in a jobs
running in a process scheduler...When process scheduler tracks out the error
in the process monitor on the on-line page...SQR must immediately kick off
the email with the attachment of log file...
 
 
Please help me to achieve this task.....Also provides sample sqr to do
this....senthil 

                                
---------------------------------
 Here's a new way to find what you're looking for - Yahoo! Answers 

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

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