SQL Scheduled Task

JA A asked on February 24, 2014 11:50

I would like to write a single and relatively basic SQL query as part of a scheduled task (select and insert) into a custom table.

Do I need to write code for this to happen? Is there an easier way to do this?

scheduled task sql

Recent Answers

Thai Tran answered on February 24, 2014 21:11

Yes, you do.

Read the following links for more information:

http://devnet.kentico.com/docs/devguide/index.html?scheduling_a_custom_code.htm http://devnet.kentico.com/docs/devguide/index.html?custom_tables_api_examples_managing_custom_table_data.htm

0 votesVote for this answer Mark as a Correct answer

JA A answered on February 25, 2014 07:18

Thanks for the reply. This is exactly why I submitted the question.

I'm surprised give the power of Kentico Reporting that a scheduled task cannot be written which uses the same fundamentals. It feels like something that "should just work".

Thanks again

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on February 26, 2014 06:48 (last edited on February 26, 2014 06:48)

@JA A, if its a feature you'd like to see added submit it to the Kentico Ideas website.

I've written dozens of custom scheduled tasks to perform many different types of actions and I willing to be only 2 or 3 of them would have been easily handled with a simple query as you mention.

0 votesVote for this answer Mark as a Correct answer

JA A answered on February 26, 2014 07:07

Thanks Brenden,

My observation is that the simplest way to get operational and aggregated data out of Kentico is through synchronous querying. This could be done completely outside of Kentico, but Im surprised there are not more folks looking for this inside of Kentico.

0 votesVote for this answer Mark as a Correct answer

JA A answered on February 26, 2014 07:57

Vote me up ;)

http://ideas.kentico.com/forums/239189-kentico-product-ideas/suggestions/5570537-update-the-scheduled-task-interface-to-allow-sql-j

0 votesVote for this answer Mark as a Correct answer