Create SQL server job with SQL SERVER.

1. Make sure you SQL Server version by using some T-SQL .

SELECT  SERVERPROPERTY('productversion'),
            SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') 

 

select @@VERSION 

 

2. Right click SQL Server Agent node in SQL Management Studio, then create new SQL job, paste you T-SQL into  command area.

 

代码

declare @filename nvarchar(100) 

set @filename='E:\David\BackUpProject\BackUpDBFolder\TestScarabGenDavid'+convert(char(10),getdate(),112)+'.bak '



BACKUP DATABASE [TestScarabGenDavid] TO DISK = @filename WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 

 

3. You can define severals jobs and schedule them as one job sequence.