Schedule Data Job

[mchiappe83]

Hi Everyone,

I need to schedule a Data Job that ends updating an Oracle table. I could obtain a Data Job in SAS DI that, when run manually, updates that table. My trials, until now, couldn't attain that objective.

I'd appreaciate a lot your guidance.

Martín

[Patrick]

@mchiappe83

If I understand you right then you've got already a working job in DIS and it's now only about how to deploy and schedule a DIS job?

Is that correct? Have you ever scheduled DIS jobs? 

[mchiappe83]

@Patrick Hi Patrick, I have scheduled Data Jobs and I could run the Data Job in DIS. When I run the Data Job in DIS, it performs as expected (reading the source and writing in the destination -an oracle table-). But when scheduled in the console, no writing in the destination occurs. Please confirm if I'm being clear and if you'd need further infor to guide me.

Thanks a lot for your time. Very much appreciated. 

Martín

[Patrick]

@mchiappe83

I can't add more than what @LinusH wrote.

DIS generates SAS code, your Date Job is in Data Flux, and there is a DIS transformation which allows you to call a Data Flux job out of SAS - so SAS is the wrapper for your Data Flux job.

I assume that running out of DIS means you run that using the DIS client - so it's going to use the user with which you have connected to DIS.

Now you use DIS and deploy your jobs. That creates .sas files (with exactly the same code than what gets executed out of DIS) and a scheduling object. I assume you then use this scheduling object to build a flow which your run via scheduler. Such jobs are run in batch and will use the batch user defined.

If this batch user doesn't have the right privileges - i.e. to access Oracle - then things will fall over. If they do then you'll see this in the log of your batch job. So that's your first place to investigate what's not working.

[mchiappe83]

Hi @Patrick 

When running out of DIS I refer to run the Data Job via the Schedule Manager in the Console. I assume that I do have the privileges, as when I run the Data Job in DIS the update in Oracle it performs as expected. 

[LinusH]

Have you looked in the log?
Also, are you using the same user in both scenarios?

[mchiappe83]

@LinusH There is no such thing as a log, as the process ends without any output.
Yes, I'm using the same user in both scenarios.
Many thanks

[mchiappe83 · Accepted solution]

Thanks everyone for your support. The solution was to reset the DIS security to its original configuration.