Announcement

Collapse
No announcement yet.

Stored Procedure in Direct SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • Stored Procedure in Direct SQL

    Dear All,

    How to use stored procedures in Direct SQL Update of Automation Agent, Could any one help me.

    Thanks and Regards
    Muthahar

  • #2
    Re: Stored Procedure in Direct SQL

    Hi Muthahar - this can definitely be done. I worked on a project where we used standard packages (rather than stored procedures) within the OTM workflow but I dont have the details to hand unfortunately.

    You should probably refer to the Technical Consultant or the DBA that is involved on your project for the best advice on how to implement what you are looking to do (I seem to remember there were quite a few guidelines that our TC gave us when we did something similar).

    Comment


    • #3
      Re: Stored Procedure in Direct SQL

      To call a package from a agent:

      Add a DirectSQL
      In the Sql Statement box call the procedure..
      (eg call glogowner.pkg_package.detail_name)

      Set the Statement Type to Stored Procedure

      That's it

      Cheers
      Gary
      Regards
      Gary Cunningham
      www.cbmc.co.uk
      www.mavenwire.com

      Comment


      • #4
        Re: Stored Procedure in Direct SQL

        don't forget to grant the procedure to GLOGADMIN

        Comment

        Working...
        X
        😀
        🥰
        🤢
        😎
        😡
        👍
        👎