Skip to main content
Question

Scheduled

  • Nov 10, 2026 12:10 PM UTC
  • 2 replies
  • 14 views

Forum|alt.badge.img+10
  • Sidekick (Customer)

Hello,

 

I created stored procedure which will update some column and I want to set up frequently, probably every night, How can I do that?

 

Should I create it through New Database Task, or another view?

I created procedure called “C_MY_PROCEDURE”, but when I want to add this through New Database Task, field → Method,I cant find it. 

 

Also, I cant find it in field Database Task → 

 

2 replies

Forum|alt.badge.img+3
  • Do Gooder (Partner)
  • Nov 10, 2026 12:21 PM UTC

Hi ​@Ed22 

Where and how did you create “C_MY_PROCEDURE”? You need to do it via developer studio and for it to appear in the method list of the database task wizard it needs to be in a package with the correct constants is the specification.

Developer studio will generate the package correctly for it to appear in the client.


Forum|alt.badge.img+10
  • Author
  • Sidekick (Customer)
  • Nov 10, 2026 12:44 PM UTC

So, I should wrap this procedure into package and it will work?