auth::sync::job::end_get_document (public)

 auth::sync::job::end_get_document -job_id job_id \
    -doc_status doc_status [ -doc_message doc_message ] \
    [ -document document ] [ -snapshot ]

Defined in packages/acs-authentication/tcl/sync-procs.tcl

Record the time that we've finished getting the document, and record the status.

Switches:

-job_id (required)

The ID of the batch job you're ending.

-doc_status (required)

-doc_message (optional)

-document (optional)

-snapshot (optional, boolean)

Set this if this is a snapshot job, as opposed to an incremental ('event driven') job.

Partial Call Graph (max 5 caller/called nodes):

Testcases:

sync_start_end

Source code:

    set snapshot_p [db_boolean $snapshot_p]

    db_dml update_doc_end {} -clobs [list $document]

Generic XQL file:

packages/acs-authentication/tcl/sync-procs.xql

PostgreSQL XQL file:

<fullquery name="auth::sync::job::end_get_document.update_doc_end">
    <querytext>
            update auth_batch_jobs
            set    doc_end_time = current_timestamp,
                   doc_status = :doc_status,
                   doc_message = :doc_message,
                   document = :document,
                   snapshot_p = :snapshot_p 
            where  job_id = :job_id
        </querytext>
</fullquery>

packages/acs-authentication/tcl/sync-procs-postgresql.xql

Oracle XQL file:

<fullquery name="auth::sync::job::end_get_document.update_doc_end">
    <querytext>
            update auth_batch_jobs
            set    doc_end_time = sysdate,
                   doc_status = :doc_status,
                   doc_message = :doc_message,
                   document = empty_clob(),
                   snapshot_p = :snapshot_p 
            where  job_id = :job_id
            returning document into :1
        </querytext>
</fullquery>

packages/acs-authentication/tcl/sync-procs-oracle.xql