Hi,
I have got a Script that takes three parameters like-:
CREATE PROCEDURE [dbo].[sp_BackupDatabases]
@databaseName sysname = null,
@backupType CHAR(1),
@backupLocation nvarchar(200)
..................
The rest of the code creates backup of the all databases present in the sql server.I use a .bat or batch file to execute the stored procedure in sql server express using windows task scheduler.
.bat file-:
sqlcmd -U sa -P enter -S .\PROCESSCUBE-PC\SQLEXPRESS –E -Q "EXEC sp_BackupDatabases @backupLocation='D:\dbbc-folder\', @backupType='F'"
But now we have upgraded to enterprise version of sql server.So now we want to use the Sql server agent job scheduling.how will i do it?Please help me out.
Thanks in advance