Schedule Stored process

RameshReddy — Wed, 19 Oct 2011 05:54:23 GMT

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

Schedule Stored process

milts — Wed, 19 Oct 2011 09:49:03 GMT

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

topic Schedule Stored process in Developers

Schedule Stored process

Schedule Stored process