Schedule Stored process

[RameshReddy]

Dear Team,

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,

RAMESH REDDY

[milts]

Hi Ramesh,

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.

ex.

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

Milton