DSXchange

There used to be a job at ADN. It would clear the log files of all the jobs in a project. Try to see if its still there. Thats one of the ways to clear the log files of multiple jobs at the same time.

Logging in with an expired unix id huh, wow, harry potter is real

cat is synonymous to union.

This has been discussed here before. Check out thispost.

O yea, thats true. The second one was F=ma. Thanks Kris.

Once again, Newtons second law, also known as law of intertia, or maybe, in your case, "law of distracted minds"

But i dont think this is something that you need to worry about. The job will run just fine. If you have to view the records, do it from the unix level by using the head and tail options.

Kris, i think prabu was just kidding as he was re-iterating newtons third law of physics.

Thats not what i meant. Just define a parameter name in your job properties and default its value to the job name you are looking for. Use that parameter name within hashes inside the notification activity. Also pay attention to what Ray asked and Kims suggestion.

Go to the job properties of the sequence job and check out the job properties. You must have checked the "Automatically handle jobs that fail". Thats why the job is finishing rather than aborting.

Yes, with great "knowledge" comes great responsibility
Anyone a spiderman fan here

Are you using the DataStage SQL Load stage to BCP the records into the database? Sounds like an obvious question but i just wanted to be sure. If you are then there must be an option in the load stage whether to remove the temp files or not. I know for sure that the UDB load stage has that option, i...

Try giving a different name for the job parameter. That might not work as its a macro name. Try giving the name of the parameter as just JobName and use it as #JobName# inside the notification activity.

Parametrize it. I am not exactly sure whether macros work in the notofication activity or not but you can surely parametrize it.

I just came back from vacation. Did not want to let this go by. Congratulations Craig. You the man