Skip to main content
L
LY_1069107912-Amethyst
12-Amethyst
January 5, 2024
Question

How to automate a service which is present on a database thing

  • January 5, 2024
  • 1 reply
  • 2205 views

Hi everyone,

 I am using a service which is calling windchill data and then storing it in thingworx local database postgres sql now I want to automate this service on a specific interval so that it will automatically execute after a certain time 

what I am thing is using a scheduler thing template but not sure how can I implement it and the Thing  on which this service is present already using database template so I can't use two template in a single thing 

 so please give me a  better understanding if anybody's have any Idea.

 

Thanks and Regards,

Lav.

1 reply

A
Arun_C16-Pearl
16-Pearl
January 5, 2024

Hi @LY_10691079 ,

 

You need to create a separete Scheduler Thing under Scheduler ThingTemplate and need to set the timing for the execution. Then in same shecduler thing you need to create the Subscription& to call the service from the respective database thing which need to execute automatically on scheduled interval time.

 

Kindly find the link , FYR. If any queries please let me know.

 

Thanks & Regards,

Arun C

    L
    LY_1069107912-AmethystAuthor
    12-Amethyst
    January 5, 2024

    ok let me try and will get back to you 

     

    Thanks for speedy reply 

      L
      LY_1069107912-AmethystAuthor
      12-Amethyst
      January 8, 2024

      Hi I tried to write the subscription but couldn't so please help me to write the subscription

       

      FYI   DB Thing name is Test_Thing and service is Test_store_Db service

       

      I have created a scheduler thing  and added time interval as well but writing subscription is stuck 

       

      so please help me to do so 

       

      Regards,

      Lav.

       

      Terms & ConditionsAccessibility statement