DB2 V7.1 questions about Jobs'launching and results'mailing 
Author Message
 DB2 V7.1 questions about Jobs'launching and results'mailing

One purpose of DB2 V7.1 is to make easy migration from MS SqlServer. On MS
SqlServer, jobs can be launched in sequence depending on previous ones, and
a mail can be sent to Outlook mailbox thru an external proc named
"xp_sendmail" in case of failure (typical administration tasks).

1) On DB2 V7.1, the only thing we can do is launch a SCRIPT from another one
(in case of job success for example). Is there a way (thru APIs), to launch
jobs - not scripts - depending of success of a previous one - so get
historics of jobs and timing and output ...?

2) How can we send a mail to an Outlook mailbox after a job failure - The
only samples in the doc are create a table function to READ mail? Why didn't
IBM furnish an API?

Thanks for your help,


Fri, 07 Mar 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. IDENTITY_VAL_LOCAL() doesn't seem to work under Linux (SuSE 8-0) db2 V7.1

2. Job 'failure', but job not failing!?

3. Wanted: Shell script to DBCC DB's and mail results

4. Notifying operators via Paging regarding Job's result

5. **************!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!Help me !!!!!!!!!!!!!!!!!!!!!!!!'''''''''''''''''''''''*************

6. 'machine vision'-related mailing

7. SQL Mail 'HELL'!!

8. Results not consistent with normal 'where'

9. DBWEB 'No Results Found' customisation

10. limit the result of 'sp_columns'

11. Use UNION to combine results sets from EXEC'ing sp's

12. Result of 'SELECT (1/2)'

Powered by phpBB® Forum Software