cancel
Showing results for 
Search instead for 
Did you mean: 

AUTORUN A QUERY

former_member522789
Participant
0 Kudos

HELLO

I have create an update query to update a udf field

I need this query to run automatically every hour

How is this possible what would be the solution, is it through an alert procedure ?

Thank you for your help

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI

You can achieve this by setting alert at a frequency of 1 hr....

But make sure that you are not updating the system table...

Former Member
0 Kudos

Hi.......

You may handle it through SDK if it is the case of UDT and UDFs.......

Regards,

Rahul

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Is this UDF in your UDT or in a system table? If later, you are not allowed to Update it directly.

Thanks,

Gordon