topic Re: Schedule Data Job in SAS Data Management

Schedule Data Job

mchiappe83 — Fri, 08 Jun 2018 16:20:22 GMT

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

Re: Schedule Data Job

Patrick — Sat, 09 Jun 2018 03:22:43 GMT

@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?

Re: Schedule Data Job

mchiappe83 — Mon, 11 Jun 2018 13:15:34 GMT

@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

Re: Schedule Data Job

LinusH — Tue, 12 Jun 2018 06:12:05 GMT

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

Re: Schedule Data Job

Patrick — Tue, 12 Jun 2018 09:10:34 GMT

@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.

Re: Schedule Data Job

mchiappe83 — Tue, 12 Jun 2018 12:33:10 GMT

@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

Re: Schedule Data Job

mchiappe83 — Tue, 12 Jun 2018 12:48:36 GMT

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.

Re: Schedule Data Job

mchiappe83 — Wed, 13 Jun 2018 23:20:55 GMT

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