Scripted Signal Management Configuration

Previous Topic

Next Topic

Book Contents

Scripted Signal Management Configuration

  1. Navigate to the

    Database

    directory, for example:

    $ cd /u01/stage/Database

  2. Start sqlplus as the Empirica Signal database user, for example:

    $ sqlplus webvdme@<TNS_NAME>

  3. When prompted, enter the password.
  4. Start logging, for example:

    SQL> spool <log file name>

  5. Execute the create_product_field_tables.sql script, for example:

    SQL> @create_product_field_tables.sql <SMC_Id>

  6. Execute the create_configurable_alerts_tables.sql

    script, for example:

    SQL> @create_configurable_alerts_tables.sql <SMC_Id>

  7. Execute the populate_signalcodelist_table.sql

    script, for example:

    SQL> @populate_signalcodelist_table.sql <SMC_Id>

  8. Execute the update_signaldrugoverview_view.sql script, for example:

    SQL> @update_signaldrugoverview_view.sql <SMC_Id>

  9. Exit sqlplus, for example:

    SQL> quit

  10. Copy 06_create_drugoverview_view.sql file from Database/update_ssm folder into sigmgt/db subfolder of Scripted Signal Management software directory. For instance, if Scripted Signal Management software installed in /u01/stage/projects/vaers_prep directory, run the following command:

    $ cp -f update_ssm/06_create_drugoverview_view.sql

    ../projects/vaers_prep/sigmgt/db

Send Feedback