Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Schedule a SQL store Proc using PF Scheduler

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Thomas Varughese
Basic Member
Posts: 7
Basic Member
3/15/2010 2:46 PM

    Can anyone help me to schedule a SQL Store proc using PF Scheduler?  I tried to use the SysCommand node and Custom Activity node to call the stored proc but went in vain…..

     
    Thanks,
     
    Thomas.
    Gary Davies
    Veteran Member
    Posts: 248
    Veteran Member
    3/15/2010 3:08 PM
      You use the SQL update node in PFI, but you have to have Integrator to do that.
      Thomas Varughese
      Basic Member
      Posts: 7
      Basic Member
      3/15/2010 3:19 PM
        I tried that but the jdbc driver configuration is giving error.... any docs on hat?

        thanks
        JudeBac
        Veteran Member
        Posts: 129
        Veteran Member
        3/17/2010 12:55 PM

          Hi Thomas,


          The discussion on JDBC driver is in  https://www.lawsonguru.co...1/Default.aspx#10941

           

          Regards

          Shane Jones
          Veteran Member
          Posts: 460
          Veteran Member
          3/24/2010 1:14 AM

            Shane Jones
            Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
            Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
            ** Teach others to fish...