UNIX for Dummies Questions & Answers

Not yet. I haven't had much time to check into the autosys database. I'll keep people informed here when I find the solution. As Kartheg noted, it seems like something we have to do ourselves as opposed to Autosys having this feature in it.

Autosys Information is stored in an Oracle database. You will need to get read access, then use SQL Plus or any similar software and view the data. Just get familiar with the tables and see whats stored.

The script I have may not work in your Shop. It would require you to make modifications to fit your shop.

Kartheg

Hi All,

I have a similar task of sending emails from AutoSys on alarms.

I have a filewatcher which watches continuously for a file. After certain time, if the file is not recevied, I need to send mail to a particular group.

I configured filewatcher job to raise MAXRUNALARM signal after this time. Is there any way that when AutoSys sees this alarm, it sends an email?

When I read this post, I could see that we need to create our own job for sending mails and there is no built-in autosys feature for the same. Is this true?

In manuals, I read about a file called notify.$AUTOSERV, which can be used for email notifications. Is this file limited to critical alarms alone and not warning alarms?

Thanks
AutoUser

Here is what I did. For us the autosys db is an oracle db. there is a table called Alarms. One of the fields (status or something) will be 43 if it's an active alarm (hasn't been taken care of). So basically I have a script read this db for 43's and just email what is in there.

Thanks for the reply rpiller.

But I dont have access to the AutoSys database tables. Looks like in that case, I need to write another script to watch time of the file watcher job.

Let me also search if there are any other ways of doign it.

Thanks

The simplest solution is to create another job that depends on the failure of the parent job. For example:

JobA - The current job you currently want to monitor
JobB - A job that is merely a shell script that emails you if JobA fails. This job depends on the failure of JobA.

That would mean creating hundreds of jobs.

We do have a script that doesn't access Autosys Database but I don't use it cause it is a nuisance. I have to find where it is located.

I don't see why you cannot get read access to Autosys Database. I am assuming your DBA is refusing to give you access and if so he/she is probably a "typical DBA".

I had the same issue with my DBA and somehow I found the user id and password stored in a report program that access the Db.

You should be able to find it somewhere. The Autosys manual clearly encourages you to read the database to produce reports.