I come from an Oracle background, but have been forced into using SQL Server for some very specific reporting.
I need to be able to schedule a job to refresh a table from a view every night.
In oracle I can do this in 2 minutes. in SQL server, I am completely lost.
I have a query
SELECT * INTO REPORTSMASTERS FROM REPORTSMASTERS_REFRESH
I need the above to be executed every night at 12am.
Right now I am doing this by hand and the task is taking up time i rather not be spending.
Any help would be greatly appreciated.