Can a mail be generated reporting that the server is down?

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 3:01 am

Hi,

In case the DataStage server goes down in the middle of the process (i.e, the jobs/sequences have been triggered for some time), can a mail be generated reporting that the server is down?

I think a health check can be done before triggering the jobs and reporting if the DataStage server is down- please advice on this also.

Any help/suggestions are highly appreciated.

Thanks,
DSUser7

ArndW · Post by **ArndW** » Sat Nov 29, 2008 5:29 am

There are numerous ways to do this. How about an hourly "AT" scheduled batch script that starts a small DS job and then checks the error code / status. If the status is invalid then send a mail.

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 7:28 am

ArndW wrote:There are numerous ways to do this. How about an hourly "AT" scheduled batch script that starts a small DS job and then checks the error code / status. If the status is invalid then send a mail. ...

Forgive my ignorance, but can you please explain me, what an hourly "AT" scheduled batch script is? How does it work? How to check the error code/status? I'm interested to know more, can you please explain these in detail?
Please mail me at ds.user7@yahoo.com, if your response is lengthy, I'm afraid I wouldn't be able to view your response as it would be premium content...please.

Thanks in advance.

chulett · Post by **chulett** » Sat Nov 29, 2008 8:49 am

dsuser7 wrote:Please mail me at ds.user7@yahoo.com, if your response is lengthy

Sorry, but that's not how things work here.

ArndW · Post by **ArndW** » Sat Nov 29, 2008 10:04 am

dsuser7, you are on Windows, so the scheduling tool is usually "AT", you can read up on that in the documentation.

ray.wurlod · Post by **ray.wurlod** » Sat Nov 29, 2008 3:15 pm

The best command to issue to determine whether the DataStage server is running is shrdump - build that into the BAT file you schedule from AT.