DSXchange

Chullet

Could you please suggest me some thing here

I have checked the option "Include Job Status in Mail" and able to see all job run information including which job got aborted.

But i need to capture the error message with which job has got failed.

Can you please suggest me how can i capture the error message in email notification

Dear All, I have requirement with when ever job fails in a sequence i need to send the error message with the job failed along with job status in email notification. I am not sure of to how to get the aborted message and send as an attchement in email Looking farward for suggestion from any one Thanks

These columns are from audit table which holds job statistics information.

Is there any specific basic language functions or macros which return the information for the create_user_id and update_user_id columns.

Dear All,

How would i get the user information for the columns create user id and update user id in server routine.

Is there any DS macro or function can i use the server routine?

Could any one please suggest me here.

Arndw,

Could you please suggest me on this.

sorry,below is the code: $INCLUDE DSINCLUDE JOBCONTROL.H Equate RoutineName To 'GetJobInfo' JobHandle = '' JobHandle = DSAttachJob(JobName, DSJ.ERRNONE) Int = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) Begin Case Case Int = DSJS.RUNFAILED Job_Status = 'Aborted' Case Int = DSJS.RUNOK Job_Status = 'Finish...

sorry missed out to give the code which i am using below is the code SINCLUDE JOBCONTROL.H Equate RoutineName To 'GetJobInfo' JobHandle = '' Int = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) Begin Case Case Int = DSJS.RUNFAILED Info = 'Aborted' Case Int = DSJS.RUNOK Info = 'Completed' Case Int = DSJS.RUN...

Dear All,

I am using the below code for job statistics in server routine


If the job name which we are not passing is invalid or not avaialable then how to handle the error which occur with the routine.

Can any one suggest me how to handle this case with failing the routine.

Dear Ray,

Could you please give me code with date column as an example with the above timestamp format.

Hi ArndW,

I am unable to see the full content.

Request you to please give the code

Dear All

I am getting the datatime as YYYYMMDD_HHMMSS when using DSJ.JOBLASTTIMESTAMP in the routine.

I need to convert YYYYMMDD_HHMMSS to YYYY-MM-DD HH:MM:SS using iconv and oconv .

Can anyone please suggest me how to do this.

Hi abhinav I have one audit table with the fields jobid, jobname, jobstatus, jobstarttime, jobendtime, createetimestamp, updatetimesramp, createuserid and updateuserid fields . I need to create audit job which will insert a record in audit table with jobstatus as running.there are two jobs running p...

Dear Abhinav

How can i use the flag/indicator to catch up the corresponding job id record value and update the same.

can any one guide me here please.

Dear All, I am running two jobs parallely which will update the audit table which have jobstatus column. while running a job ,there will be a record created with 'running' status for each job so two records will be created in the audit table. once the bothe job has completed the run,status shall be ...