How to send SMS about the status of sequence job?

rafik2k · Post by **rafik2k** » Mon Jul 09, 2007 3:04 pm

Hi All,
We have created one main sequence job which inturn calls another 15 inner sequence jobs. There is almost total 250 jobs in the sequence and which takes almost 24 hours to finish.

My requirement is to send status (success/abort/fail) SMS message upon completion of each inner sequence jobs.

Could you please anyone let me know what is pre-requisite on the same and what are the steps I need to setup in order to send SMS on cell.

Any help or information on same would be a great help.

Thanks and Regards,
Rafik

ArndW · Post by **ArndW** » Mon Jul 09, 2007 3:11 pm

There is no builtin SMS send utility in DataStage, but most service providers have utlities that redirect email to SMS. Since you can call programs from DataStage and all mail utilities that I know of have some sort of command line interface you can solve your problem that way. DataStage even comes with an email template script that you can use or modify to your liking.

chulett · Post by **chulett** » Tue Jul 10, 2007 6:58 am

So, just send a short email to their cell phone 'email address'. For example, I send messages to my Sprint phone using '##########@messaging.sprintpcs.com' as the 'send to' address where the #s are the 10 digit phone number. No template tweaking or change of any kind needed. All carriers seem to have something equivalent.

rafik2k · Post by **rafik2k** » Tue Jul 10, 2007 8:00 am

Thanks ArndW and Craig for sharing valuable information.

I will test the jobs and will let know the outcomes.

Thanks and Regards,
Rafikul

ray.wurlod · Post by **ray.wurlod** » Tue Jul 10, 2007 11:27 am

It may be that Sprint does not extend to South Africa, but most mobile phone providers have a similar service.

rafik2k · Post by **rafik2k** » Fri Jul 13, 2007 12:38 am

ray.wurlod wrote:It may be that Sprint does not extend to South Africa, but most mobile phone providers have a similar service. ...

Thanks Ray

I will check that and will send SMS at ray.craig.ArndW@dsxchange.com

prashkvrk · Post by **prashkvrk** » Thu Jul 19, 2007 2:50 am

As Ray said, an email can be redirected to a mobile as an sms. However not in all service providers we have this option. Here in India even though there is this option of sending an email to a mobile as an sms, most of the time it doesn't work. But I am not sure whether this is applicable to CDMA mobiles also!
I think you can try this. In Recepient email adress you can give like this:
mobilenumber@serviceprovider.com..

But please note that not all mobile service providers give this option of sending an email as an sms !

Prasad !