Scheduling the Windows Batch File through MSSQLServer Scheduler

Step 1:Click on Jobs to create a new job and configure the  following shown below and fill the job name and user credentials to execute the Job

Step 2:Click on Steps to configure the Steps Name to be executed in the Job and select the following
Step Name     : Name of Step to be executed in Job ( ETL_Data_Mart_Load)
Type              : Operating System (CmdExec)
Run As              : CmdExecProxy
Command     : cmd.exe /c "Batch File Location"

For e.g: cmd.exe /c "C:\Data_Mart_Load.bat"

Step 3:Click on Advance Option to set the Log file location of the Job as follows

Step 4:Schedule the ETL Run depending upon your Dashboard Refresh interval