Sp_GetMachineByApsRule_copy1.md 1.11 KB

Sp_GetMachineByApsRule_copy1 (procedure)

主计划:自定义排程规则(根据APS规则选择最合适机台)

  • Type: PROCEDURE
  • Deterministic: NO
  • SQL data access: CONTAINS SQL

Parameters

# Mode Name Type
1 IN sWorkOrderGuid varchar(5000)
2 IN sWorkOrderProcessid varchar(100)
3 IN sProcessid varchar(100)
4 IN p_sMachineid varchar(100)
5 IN sBrId varchar(100)
6 IN sSuId varchar(100)
7 OUT sReturnMachineId varchar(250)
8 OUT sReturnInfo text

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURESpGetMachineByApsRule_copy1'._

Narrative

Business context: Backup / snapshot variant of Sp_GetMachineByApsRule (_copy1 suffix). Per wiki convention, backup objects are not narrated (see the index).

What it does: Same as Sp_GetMachineByApsRule at the time of copy.

Invocation: Not expected to be called from production code; verify before relying on it.