trigger email

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

trigger email

Post by admin »

TWlzdGVycywNCmlzIHRoZXJlIGEgd2F5LCBpbiBkYXRhc3RhZ2UsIHRvIHNlbmQgYW4gZW1haWwg
d2hlbiBzb21lIGNvbmRpdGlvbiBvY2N1cnM/DQpUa3MsDQpBbGV4DQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

trigger email

Post by admin »

Alex:

This is the ROUTINE that I use to send mails, using DSSendMail function.
You have to contact to your notes administrator to determine the value to
set for: xFrom and xServer.

Parameteres pmL1..pmL20 are each line that I want to include in the note.

This routine receives the following parameters:
pmSendTo
pmSubject
pmImportancia
pmL1
pmL2
pmL3
pmL4
pmL5
pmL6
pmL7
pmL8
pmL9
pmL10
pmL11
pmL12
pmL13
pmL14
pmL15
pmL16
pmL17
pmL18
pmL19
pmL20

*
* Envio de notas
*
Ans = "";
Deffun DSSendMail(A);
*
xFrom = "From:notificacion-etl@osde.com.ar";
xTo = "To:":pmSendTo;
xSubject = "Subject:":pmSubject;
xServer = "Server:osde-central-2.osde";
xBody = "Body: IMPORTANCIA-":pmImportancia;
xBody = xBody:" \n \n":pmL1;
xBody = xBody:" \n":pmL2;
xBody = xBody:" \n":pmL3;
xBody = xBody:" \n":pmL4;
xBody = xBody:" \n":pmL5;
xBody = xBody:" \n":pmL6;
xBody = xBody:" \n":pmL7;
xBody = xBody:" \n":pmL8;
xBody = xBody:" \n":pmL9;
xBody = xBody:" \n":pmL10;
xBody = xBody:" \n":pmL11;
xBody = xBody:" \n":pmL12;
xBody = xBody:" \n":pmL13;
xBody = xBody:" \n":pmL14;
xBody = xBody:" \n":pmL15;
xBody = xBody:" \n":pmL16;
xBody = xBody:" \n":pmL17;
xBody = xBody:" \n":pmL18;
xBody = xBody:" \n":pmL19;
xBody = xBody:" \n":pmL20;
xBody = xBody : " \n \n \n*** DataStage - Cobranzas ***";
*
rc = DSSendMail(xFrom:"\n":xTo:"\n":xSubject:"\n":xServer:"\n":xBody:"\n");
*
IF rc "0"
THEN
CALL DSLogFatal("Error en el DSSendMail.","MSG");
Ans = "ERROR";
END


Guillermo P. Barsky - gbarsky@osde.com.ar
Gerencia de Sistemas - Desarrollo

OSDE Binario - Filial Metropolitana
Alem 1067, Piso 16
TE (5411)4510-4330, Fax (5411)4510-5480
http://www.osde.com.ar



"Alex Martins"
Para:
Enviado por: cc:
datastage-users-bounces Asunto: trigger email
@oliver.com


17/02/2004 01:48 p.m.
Por favor, responda a
DataStage Users
Discussion List






Misters,
is there a way, in datastage, to send an email when some condition occurs?
Tks,
Alex
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users



_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

trigger email

Post by admin »

R3VpbGxlcm1vLA0KSSBub3RpY2UgdGhlIHdheSB5b3UgZGVmaW5lIGEgZnVuY3Rpb246DQogDQpE
ZWZmdW4gRFNTZW5kTWFpbChBKTsNCg0KSSBjYW7CtHQgcnVuIGEgam9iIGNvbnRyb2wgaGVyZSB0
aGF0IGhhdmUgdGhpczoNCiANCkRlZmZ1biBVSGFzaExvb2t1cChBMSwgQTIsIEEzKSBDYWxsaW5n
ICJEU1UuVXRpbGl0eUhhc2hMb29rdXAiDQpQX0RBVEFfSU5JQ0lBTCA9IFVIYXNoTG9va3VwKCJI
U0hfTUFYX0NPUkRXMDgyIiwxLDEpDQogDQpJdCBnaXZlcyBubyBtZXNzYWdlLCBidXQgYXR0cmli
dXRlcyBubyB2YWx1ZSB0byBQX0RBVEFfSU5JQ0lBTCBlaXRoZXIuDQpDb3VsZCB5b3UgaGVscCBt
ZSB3aXRoIHRoaXMgdG9vPw0KIA0KTXVjaGFzIGdyYWNpYXMsDQpBbGV4DQogDQotLS0tLU1lbnNh
Z2VtIG9yaWdpbmFsLS0tLS0gDQpEZTogZ2JhcnNreUBvc2RlLmNvbS5hciBbbWFpbHRvOmdiYXJz
a3lAb3NkZS5jb20uYXJdIA0KRW52aWFkYTogdGVyIDE3LzAyLzIwMDQgMTQ6MTAgDQpQYXJhOiBk
YXRhc3RhZ2UtdXNlcnNAb2xpdmVyLmNvbSANCkNjOiANCkFzc3VudG86IFJlOiB0cmlnZ2VyIGVt
YWlsDQoNCg0KDQoNCg0KDQoNCglBbGV4Og0KCQ0KCVRoaXMgaXMgdGhlIFJPVVRJTkUgdGhhdCBJ
IHVzZSB0byBzZW5kIG1haWxzLCB1c2luZyBEU1NlbmRNYWlsIGZ1bmN0aW9uLg0KCVlvdSBoYXZl
IHRvIGNvbnRhY3QgdG8geW91ciBub3RlcyBhZG1pbmlzdHJhdG9yIHRvIGRldGVybWluZSB0aGUg
dmFsdWUgdG8NCglzZXQgZm9yOiB4RnJvbSBhbmQgeFNlcnZlci4NCgkNCglQYXJhbWV0ZXJlcyBw
bUwxLi5wbUwyMCBhcmUgZWFjaCBsaW5lIHRoYXQgSSB3YW50IHRvIGluY2x1ZGUgaW4gdGhlIG5v
dGUuDQoJDQoJVGhpcyByb3V0aW5lIHJlY2VpdmVzIHRoZSBmb2xsb3dpbmcgcGFyYW1ldGVyczoN
CglwbVNlbmRUbw0KCXBtU3ViamVjdA0KCXBtSW1wb3J0YW5jaWENCglwbUwxDQoJcG1MMg0KCXBt
TDMNCglwbUw0DQoJcG1MNQ0KCXBtTDYNCglwbUw3DQoJcG1MOA0KCXBtTDkNCglwbUwxMA0KCXBt
TDExDQoJcG1MMTINCglwbUwxMw0KCXBtTDE0DQoJcG1MMTUNCglwbUwxNg0KCXBtTDE3DQoJcG1M
MTgNCglwbUwxOQ0KCXBtTDIwDQoJDQoJKg0KCSogRW52aW8gZGUgbm90YXMNCgkqDQoJQW5zID0g
IiI7DQoJRGVmZnVuIERTU2VuZE1haWwoQSk7DQoJKg0KCXhGcm9tICAgID0gIkZyb206bm90aWZp
Y2FjaW9uLWV0bEBvc2RlLmNvbS5hciI7DQoJeFRvICAgICAgPSAiVG86IjpwbVNlbmRUbzsNCgl4
U3ViamVjdCA9ICJTdWJqZWN0OiI6cG1TdWJqZWN0Ow0KCXhTZXJ2ZXIgID0gIlNlcnZlcjpvc2Rl
LWNlbnRyYWwtMi5vc2RlIjsNCgl4Qm9keSAgICA9ICJCb2R5OiBJTVBPUlRBTkNJQS0iOnBtSW1w
b3J0YW5jaWE7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIFxuIjpwbUwxOw0KCXhCb2R5ICAgID0g
eEJvZHk6IiBcbiI6cG1MMjsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDM7DQoJeEJvZHkg
ICAgPSB4Qm9keToiIFxuIjpwbUw0Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MNTsNCgl4
Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDY7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUw3
Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MODsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4i
OnBtTDk7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxMDsNCgl4Qm9keSAgICA9IHhCb2R5
OiIgXG4iOnBtTDExOw0KCXhCb2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTI7DQoJeEJvZHkgICAg
PSB4Qm9keToiIFxuIjpwbUwxMzsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDE0Ow0KCXhC
b2R5ICAgID0geEJvZHk6IiBcbiI6cG1MMTU7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwx
NjsNCgl4Qm9keSAgICA9IHhCb2R5OiIgXG4iOnBtTDE3Ow0KCXhCb2R5ICAgID0geEJvZHk6IiBc
biI6cG1MMTg7DQoJeEJvZHkgICAgPSB4Qm9keToiIFxuIjpwbUwxOTsNCgl4Qm9keSAgICA9IHhC
b2R5OiIgXG4iOnBtTDIwOw0KCXhCb2R5ICAgID0geEJvZHkgOiAiIFxuIFxuIFxuKioqIERhdGFT
dGFnZSAtIENvYnJhbnphcyAqKioiOw0KCSoNCglyYyA9IERTU2VuZE1haWwoeEZyb206IlxuIjp4
VG86IlxuIjp4U3ViamVjdDoiXG4iOnhTZXJ2ZXI6IlxuIjp4Qm9keToiXG4iKTsNCgkqDQoJSUYg
cmMgPD4gIjAiDQoJVEhFTg0KCSAgIENBTEwgRFNMb2dGYXRhbCgiRXJyb3IgZW4gZWwgRFNTZW5k
TWFpbC4iLCJNU0ciKTsNCgkgICBBbnMgPSAiRVJST1IiOw0KCUVORA0KCQ0KCQ0KCUd1aWxsZXJt
byBQLiBCYXJza3kgLSBnYmFyc2t5QG9zZGUuY29tLmFyDQoJR2VyZW5jaWEgZGUgU2lzdGVtYXMg
LSBEZXNhcnJvbGxvDQoJDQoJT1NERSBCaW5hcmlvIC0gRmlsaWFsIE1ldHJvcG9saXRhbmENCglB
bGVtIDEwNjcsIFBpc28gMTYNCglURSAoNTQxMSk0NTEwLTQzMzAsIEZheCAoNTQxMSk0NTEwLTU0
ODANCglodHRwOi8vd3d3Lm9zZGUuY29tLmFyDQoJDQoJDQoJICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQoJICAgICAgICAgICAgICAgICAgICAgICJBbGV4IE1hcnRpbnMiICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIDxB
bGV4QHByb2l0LmNvbS5icj4gICAgICAgICAgUGFyYTogICAgIDxkYXRhc3RhZ2UtdXNlcnNAb2xp
dmVyLmNvbT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
DQoJICAgICAgICAgICAgICAgICAgICAgIEVudmlhZG8gcG9yOiAgICAgICAgICAgICAgICAgY2M6
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIGRhdGFz
dGFnZS11c2Vycy1ib3VuY2VzICAgICAgQXN1bnRvOiAgIHRyaWdnZXIgZW1haWwgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJ
ICAgICAgICAgICAgICAgICAgICAgIEBvbGl2ZXIuY29tICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIDE3LzAyLzIwMDQg
MDE6NDggcC5tLiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAg
ICAgICAgICAgICAgICAgIFBvciBmYXZvciwgcmVzcG9uZGEgYSAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgIERhdGFTdGFnZSBVc2Vy
cyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAg
ICAgICAgICAgICAgIERpc2N1c3Npb24gTGlzdCAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQoJICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgDQoJDQoJDQoJDQoJDQoJTWlzdGVycywNCglpcyB0aGVyZSBhIHdheSwgaW4g
ZGF0YXN0YWdlLCB0byBzZW5kIGFuIGVtYWlsIHdoZW4gc29tZSBjb25kaXRpb24gb2NjdXJzPw0K
CVRrcywNCglBbGV4DQoJX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX18NCglkYXRhc3RhZ2UtdXNlcnMgbWFpbGluZyBsaXN0DQoJZGF0YXN0YWdlLXVzZXJzQG9s
aXZlci5jb20NCglodHRwOi8vd3d3Lm9saXZlci5jb20vbWFpbG1hbi9saXN0aW5mby9kYXRhc3Rh
Z2UtdXNlcnMNCgkNCgkNCgkNCglfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fXw0KCWRhdGFzdGFnZS11c2VycyBtYWlsaW5nIGxpc3QNCglkYXRhc3RhZ2UtdXNl
cnNAb2xpdmVyLmNvbQ0KCWh0dHA6Ly93d3cub2xpdmVyLmNvbS9tYWlsbWFuL2xpc3RpbmZvL2Rh
dGFzdGFnZS11c2Vycw0KCQ0KDQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

trigger email

Post by admin »

Create a job sequence. Use a Notification Activity to send an email. Use the trigger on a preceding activity (for example the exit status of a Job Activity) to cause the Notification Activity to be invoked. Compile the job sequence then examine the code that is generated (Job properties, Job Control tab).
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked