Server name and project name in email subject line

avneeshrai · Post by **avneeshrai** » Fri Apr 18, 2008 3:51 am

Hi,
How do we add the DS Server name and the Project name to the e-mails (Email Subject Line) produced following job execution.

I have searched this forum and not found any posts.

thanks

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 3:55 am

The subject can include job parameters. So you can run your job with one or two extra parameters in which these values can be set in the job sequence that runs the job (using a DS Macro), or just let them have appropriate defaults.

avneeshrai · Post by **avneeshrai** » Fri Apr 18, 2008 4:05 am

Thanks Ray,

I am using DSHostName , but it is giving me the value 'localhost' in the email!

I can use job parameters , but I wanted this to come from DS so that this job can be portable across projects.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 4:58 am

Try using an ExecuteCommand activity. Execute the command hostname (which is the same on UNIX or Windows) and use the command output, stripped of @FM characters, as the parameter value.

avneeshrai · Post by **avneeshrai** » Mon Apr 21, 2008 12:38 am

Thanks for your inputs Ray, the issue stil persists!

I have built a sample job where we have

UserVariableStage--> ExecuteCommandStage--> NotificationStage

In the ExecuteCommand stage if I use hostname, and in the email subject if I use #CMD.$CommandOutput# where CMD is the execute command stage name I am getting the following error:

Parameter 4 ('') does not start with a keyword

(@SendFailEmessage): Controller problem: Unhandled failure (-19) encountered calling routine DSSendMailIf I use any other variable the job works fine, ex if I use #CMD.$ReturnValue#

Also when I go to the DS administrator and select the project and use the command I get the error

"Verb "HOSTNAME" is not in your VOC"

Currently I am using DSHostName , but it is giving 'localhost' as output !

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 2:48 am

Did I not specify "trimmed of field mark characters"?

Code: Select all

Trim(#CMD.$CommandOutput#,@FM,"A")

The Admininstrator client does not execute natively in the operating system shell. But you can open one.

Code: Select all

DOS /C hostname

avneeshrai · Post by **avneeshrai** » Mon Apr 21, 2008 3:57 am

Hi Ray,

Still getting the error:

JobControl (DSSendMail): Parameter 4 (',"@FM","A")') does not start with a keyword
Unhandled failure (-19) encountered calling routine DSSendMail

I even tried to use " around @FM in Trim(#CMD.$CommandOutput#,@FM,"A").

Also Ray, when I use DSHostName macro, is there anything we can do to get the box name instead of 'localhost' as the return value?

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 4:55 am

No space between the word Trim and its following left parenthesis.

No to your question about DSHostName.

avneeshrai · Post by **avneeshrai** » Mon Apr 21, 2008 6:40 am

Hi Ray,

I checked that also . There are No spaces between the word Trim and its following left parenthesis.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Mon Apr 21, 2008 4:43 pm

Then why is it complaining of Parameter 4 (',"@FM","A")') ?

JITeam · Post by **JITeam** » Tue Apr 22, 2008 4:44 am

Hi All,

Is it possible to capture this box name with out using the command stage as command stage might not work on UNIX env.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Apr 22, 2008 3:26 pm

Welcome aboard. We are not talking about the Command stage here; we're talking about the Execute Command activity in a job sequence.

satheesh_color · Post by **satheesh_color** » Thu Apr 24, 2008 7:08 am

Hi,

Did you try with the below DS macros

DSHostName : ":Notification (" : Substrings(DSProjectName,4,4) : ") - " : Subject

Satheesh.