10-19-2011 01:54 AM
Kindly any one help me out how to schedule diffrent stored process in one job..? below find my query
I have created one DAILY job in that i want execute my all daily reports wich are in the diffrent stored process i have already craeted...any idea how to do this........?
thanks in advance,
10-19-2011 05:49 AM
How about including the other stored processes in the daily job?
Inside the .sas of your daily job, add %include statements at the bottom depending on the order of your choice.
%include "<path of .sas>\my_next_job.sas";
%include "<path of .sas>\my_next_job_again.sas";
But if you want to have some error handlings, in case a job fails, you'll have to create a control table and other stuffs for that.
Hope this helps.