scoped application : I need to run schedule job to update values of tables in a scoped application

[vivekanand_am]

scoped application : I need to run schedule job to update values of tables in a scoped application

I did : I gave write and create check in the table, control section. I am not sure what else i need to do to make scheduled job run.

Note : Script runs fine when i try using background script but it doesn't run when i try to execute it in schedule job.

Please advise what could be the issue.

[Chuck Tomasi]

Have you created the scheduled job within your application's scope?

Use the application picker and select your application before creating the scheduled job, or create the scheduled job from Studio.

I've done this and had no issues.

[aleck_lin]

Chuck,

Is it possible to dynamically create a scheduled job record (sysauto_script)? I've tried it and I'm getting the following error...

"Security restricted: Create operation against 'sysauto_script' from scope 'x_snc_some_app' has been refused due to the table's cross-scope access policy"

I looked at the table Application Access tab, and sysauto_script seems to be read only, so I'm guessing there's some type of magic within Studio that allows for the creation, but not dynamically? 

[Chuck Tomasi]

Hi Aleck,

I was able to reproduce the situation you had using scripts background. I noticed that I can create a schedule job from the standard menu module. It's not specific to studio. This is exactly what application access should be doing-preventing your application from interfering with another applications and data via script or other non-interactive method.

[aleck_lin]

Hey Chuck,

I guess I didn't really mean it's specific to studio; I meant that you can only create it through the UI. I'm so used to the global scope where you can just create a thread in sys_trigger or sysauto_script using scripting. Am I to assume that this is something that's explicitly prevented through scoped app? Meaning that we're not allowed to dynamically create a scheduled job through script? 

thanks,

Aleck