-BCP JOB SCHEDULING- SQL SERVER MANAGEMENT STUDIO. -PRAJWAL -PRAMOD -KAVISH. CREATING NEW JOB. - Make sure that the SQL SERVER AGENT is started - Right click on jobs, select new job. Defining the Job .
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
- Make sure that the
SQL SERVER AGENT is started
- Right click on jobs, select new job
Click STEPS and click on the NEW button
exec sp_configure 'show advanced options',1
exec sp_configure 'xp_cmdshell',1
declare @command nvarchar(4000), @command1 nvarchar(4000), @command2 nvarchar(4000)
set @command=‘ bcp AdventureWorks.person.address out C:\backup\b.txt -c -S INFCH02817 -U kavish -P kavish'
set @command1='b cp AdventureWorks.HumanResources.EmployeeAddress out C:\backup\b1.txt -c -S INFCH02817 -U kavish -P kavish'
set @command2=‘ bcp AdventureWorks.HumanResources.Department out C:\backup\b2.txt -c -S INFCH02817 -U kavish -P kavish'
exec xp_cmdshell @command
exec xp_cmdshell @command1
exec xp_cmdshell @command2