| Siebel Administration > How to run generate Triggers in Siebel GUI and Server Manager
Generate Triggers
run task for comp GenTrig with EXEC=True,Remove=True,PrivUser=siebel,PrivUserPass=[siebelpswd],ALERTLEVEL=2,ERRORFLAGS=1,TRACEFLAGS=1,SQLFLAGS=8run task for comp GenTrig with EXEC=True,Remove=False,PrivUser=siebel,PrivUserPass=[siebelpswd],ALERTLEVEL=2,ERRORFLAGS=1,TRACEFLAGS=1,SQLFLAGS=8
To run the Generate Triggers server komponent from GUI
- Navigate to the Administration - Server Management screen, and then the Jobs view.
- In the Jobs list, click New.
- In the Component/Job field, click the select button.
- In the Components/Jobs dialog box, in the Find window, choose Name.
- In the Starting With window, enter the following text, and then click Go:
Generate Triggers
- Now, in the Job Parameters applet, you need to provide the following four parameters :
EXEC : TRUE
Remove : TRUE
Privileged User : "Database Table Owner Name"
Privileged User Password : "Table Owner Password"
- Click on Start.
- After few seconds, refresh the view (by clicking on "Execute Query" button), you will see Execution Server will get assigned to the request and Status changes to "Active".
After few minutes, again refresh the record and once the trigger gets generated, Status changes to "Success"Upon completion, the Siebel Server displays Success or Error in the Status field.
- To view log details, do the following:
- Click the Tasks link.
- In the Tasks list, locate the job you started.
- Examine the records in the Log list.
- Now, in the Job Parameters applet, you need to provide the following four parameters :
EXEC : TRUE
Remove : FALSE
Privileged User : "Database Table Owner Name"
Privileged User Password : "Table Owner Password"
- Press submit and wait till you get success result.
- Run one of these two sqls
select VALUE from SIEBEL.S_SRM_REQ_PARAM
select * from SIEBEL.S_SRM_REQ_PARAM
There should be two rows where the Siebel password is displayed
Update the value to something rubbish or delete these records.
|
