SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Schedule Data Job

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Schedule Data Job

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


Accepted Solutions
Solution
a week ago
Occasional Contributor
Posts: 19

Re: Schedule Data Job

Posted in reply to mchiappe83

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

View solution in original post


All Replies
Respected Advisor
Posts: 4,678

Re: Schedule Data Job

Posted in reply to mchiappe83

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

Occasional Contributor
Posts: 19

Re: Schedule Data Job

[ Edited ]

@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

Respected Advisor
Posts: 4,678

Re: Schedule Data Job

Posted in reply to mchiappe83

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

Occasional Contributor
Posts: 19

Re: Schedule Data Job

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. 

Super User
Posts: 5,852

Re: Schedule Data Job

Posted in reply to mchiappe83
Have you looked in the log?
Also, are you using the same user in both scenarios?
Data never sleeps
Occasional Contributor
Posts: 19

Re: Schedule Data Job

[ Edited ]
Posted in reply to 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

Solution
a week ago
Occasional Contributor
Posts: 19

Re: Schedule Data Job

Posted in reply to mchiappe83

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 245 views
  • 1 like
  • 3 in conversation