Urgent: Is there any way to know who forced out a job.

sharas · Post by **sharas** » 23 Feb 2010 3:51

Hi All,

Is there any way to know who forced out a job or a table?

I do not see this information in log of the job.

Is this information logged ?

Thanks,
Sharas.

LordOfAfford · Post by **LordOfAfford** » 23 Feb 2010 5:43

Hi Sharas,

If would like to know too.
You can see a job forcing another one and keep track of it with conditions between them but not who forced a job onto the AJF apparantly it only says DAILY FORCED.

Greetz

hipikll · Post by **hipikll** » 23 Feb 2010 6:29

ctmlog list [datefrom] [timefrom] [dateto] [timeto] | grep [jobname]

sharas · Post by **sharas** » 24 Feb 2010 2:34

Hi Hipkill,

I tried by ctmlog but it did not get the id which forced out the jobs.

Below is the log for one particular job. It does not show the account information which forced out the job.

|0223|0930|IND001_FL1TA002599A00 |2gr2p|CS|5065|ORDERED JOB:28640; DAILY FORCED, ODATE 20100223 |
|0223|0930|gphl210 |00000|CS|5212|JOB IND001_FL1TA002599A00, TABLE IND001_FL1TA002599A FORCED |
|0223|0930|IND001_FL1TA002599A-D |2gr2q|CS|5065|ORDERED JOB:28641; DAILY FORCED, ODATE 20100223 |
|0223|0930|gphl210 |00000|CS|5212|JOB IND001_FL1TA002599A-D, TABLE IND001_FL1TA002599A FORCED |
|0223|0930|IND001_FL1TA002599A-F |2gr2r|CS|5065|ORDERED JOB:28642; DAILY FORCED, ODATE 20100223 |
|0223|0930|gphl210 |00000|CS|5212|JOB IND001_FL1TA002599A-F, TABLE IND001_FL1TA002599A FORCED |

philmalmaison · Post by **philmalmaison** » 24 Feb 2010 3:06

as you have code |00000| it's an external routine that have Force the table/jobs probably a script using ctmpsm command line.

regards
philmalmaison

hipikll · Post by **hipikll** » 24 Feb 2010 3:55

As Ph wrote, it was forced by ctmpsm.

you can run unix 'last' command to know, who was in the time of force loged on the machine. But it is just informational, as you can not know, what the user did.
But, if you are root, you can look in the bash_history file of the user (if he uses it)

.