Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Scheduling Issues

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 116
Accepted Solution

Scheduling Issues

Hi all,

 

I've got a strange issue with a scheduled job, it was set up using the prepare data tool and was working fine until I modified the underlying data set, manually running the import worked fine but the scheduled version threw up data issues (it was missing the new fields).

 

As a work around I deleted the schedule trigger (using the data prep tool) and just planned to manually run until I could investigate, however to my suprise the job has continued to run every hour but now seems to work correctly.

 

On the downside I can't find any reference to how this job is being triggered either in data prep tool or using management console. There are no duplicate jobs or anything like that so I'm confused and reluctant to modfy further or create new jobs until I understand whats happening.

 

Can anyone give me any tips? 

 

 

 


Accepted Solutions
Solution
‎05-02-2017 06:22 AM
Occasional Contributor
Posts: 13

Re: Scheduling Issues

Welcome!!

Easy way to delete the existing scheduled code is just go in to the scheduling tab in data query (Small round clock symbol) open it select the existing scheduling (tick on check box) and then delete it. then save that data query then run it.
again go to the same tab, select the scheduling time and save it.

This will replace the existing (previous ) code to new Code........

Regards;
Jim

View solution in original post


All Replies
Occasional Contributor
Posts: 13

Re: Scheduling Issues

In answer to your question regarding the Query schedulling for data load in LASR.

 

As and when you will modify any thing in your data query like new column add or remove or any changes apart from data updated you will have to re-schedule SASVA Data Query Scheduling tab...

as there is a back-end code is generated when you schedule it and that code will set to run in your scheduling job so whenever you change anything in your data query that code will not change automatically so You will have to delete the existing scheduling code and re-schedule the same,

 

 

let me know if you need more clarity on it..

 

Regards;

Jim

Frequent Contributor
Posts: 116

Re: Scheduling Issues

Thank you,

 

whats the best method for deleting the exisitng code? I had assumed that the prepare data tool would handle that for me.

Solution
‎05-02-2017 06:22 AM
Occasional Contributor
Posts: 13

Re: Scheduling Issues

Welcome!!

Easy way to delete the existing scheduled code is just go in to the scheduling tab in data query (Small round clock symbol) open it select the existing scheduling (tick on check box) and then delete it. then save that data query then run it.
again go to the same tab, select the scheduling time and save it.

This will replace the existing (previous ) code to new Code........

Regards;
Jim
Frequent Contributor
Posts: 116

Re: Scheduling Issues

Great, thank you, I'll make a note so that the team remember to follow that step in future.

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 252 views
  • 1 like
  • 2 in conversation