As in other PROC and DATA steps, you can use only a view descriptor or other SAS data set in an SQL procedure statement, not an access descriptor. If you did not create the DBF file, you must be ...

To do this, we’ll use an SQL Server Agent Job. Using SQL Management Studio, create a new SQL Server Agent Job: Fill in the general details and then go to the Steps page to add a couple of steps.