When using "Communications Outbound Manager" business service Siebel create a job record in "S_SRM_REQUEST" table. You can easily check the status of these jobs by using below query which is written for MS SQL Manager Studio.
SELECT STATUS,CREATED,ROW_ID,DESC_TEXT,ENTERPRISE_NAME,EXEC_SRVR_NAME,PARAM_VAL,RESP_TEXT,COMPLETION_TEXT
FROM S_SRM_REQUEST
WHERE 1=1
AND DATEPART(YEAR,CREATED) = '2022'
AND DATEPART(MONTH,CREATED) = '04'
AND DATEPART(DAY,CREATED) = '06'
AND (PARAM_VAL LIKE '%SendMessage%' OR PARAM_VAL LIKE '%CreateRequest%')
ORDER BY CREATED DESC
Comments
Post a Comment