topic Re: Schedule SAS JOB USING Windows Task scheduler in SAS Procedures

Schedule SAS JOB USING Windows Task scheduler

chennupriya — Mon, 09 Nov 2015 19:23:32 GMT

Hi I have a sas program which updates a table in sql server everytime i run the sas code in base sas 9.4 . But that code need to be run weekly and mine is desktop sas and i need to schedule the job using windows task scheduler . Can anyone pls help

how is the process as i have no idea about it

Thanks

Re: Schedule SAS JOB USING Windows Task scheduler

pearsoninst — Mon, 09 Nov 2015 20:14:40 GMT

Open Task Scheduler by clicking the Start button, clicking Control Panel, clicking System and Security, clickingAdministrative Tools, and then double-clicking Task Scheduler.‌ If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Click the Action menu, and then click Create Basic Task.
Type a name for the task and an optional description, and then click Next.
Do one of the following:
- To select a schedule based on the calendar, click Daily, Weekly, Monthly, or One time, click Next; specify the schedule you want to use, and then click Next.
- To select a schedule based on common recurring events, click When the computer starts or When I log on, and then click Next.
- To select a schedule based on specific events, click When a specific event is logged, click Next; specify the event log and other information using the drop-down lists, and then click Next.
To schedule a program to start automatically, click Start a program, and then click Next.
Click Browse to find the program you want to start, and then click Next.
Click Finish.

If you want a task to run when the computer starts, whether a user is logged on or not, follow these steps.

Open Task Scheduler by clicking the Start button clicking Control Panel, clicking System and Security, clickingAdministrative Tools, and then double-clicking Task Scheduler.‌ If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Click the Action menu, and then click Create Basic Task.
Type a name for the task and an optional description, and then click Next.
Click When the computer starts, and then click Next.
To schedule a program to start automatically, click Start a program, and then click Next.
Click Browse to find the program you want to start, and then click Next.
Select the Open the Properties dialog for this task when I click Finish check box and click Finish.
In the Properties dialog box, select Run whether user is logged on or not, and then click OK.

Re: Schedule SAS JOB USING Windows Task scheduler

chennupriya — Mon, 09 Nov 2015 21:00:16 GMT

i did the same way but i get an error which is indicated below .Pls help

ERROR: Unrecognized SAS option name :\Jack_cash\SAMPLECODE.LOG".
ERROR: (SASXKRIN): KERNEL RESOURCE INITIALIZATION FAILED.
ERROR: Unable to initialize the SAS kernel

Re: Schedule SAS JOB USING Windows Task scheduler

LinusH — Tue, 10 Nov 2015 08:05:54 GMT

Seems you are mising the drive letter in the search path.

There might be another syntax since it expects a option name, not an option parameter.

If you run the task as System, there can be problems referring to drive letters not set up by the BIOS.

Re: Schedule SAS JOB USING Windows Task scheduler

chennupriya — Tue, 10 Nov 2015 15:30:09 GMT

Sorry I couldnt understand what u have said . Below is the link i am using to create a bat file . Pls help me if i am wrong

"C:\Program Files\sashome\SASFoundation\9.4\sas.exe" -SYSIN "C:\test1.sas -LOG "C:\test1.log" -PRINT "C:\test1.lst"

Re: Schedule SAS JOB USING Windows Task scheduler

LinusH — Tue, 10 Nov 2015 17:14:27 GMT

It seems you missed a double quote after .sas.