Automate job schedule
-
i have to schedule backup of particular schema objects, using sql server agent jobs. in database there is five schema like schema [a] [a].tbl_a -- Table [a].usp_a --Procedures [a].fn_a -- udf schema[b] [b].tbl_b --Table [b].usp_b --Procedures [b].fn_b --udf where [a] and [b] are the schemas. now i have to schedule full backup of only "[a]" schema objects. And there is only one file group(Primary) for database. using sql server agent job,is it possible or not?
-
i have to schedule backup of particular schema objects, using sql server agent jobs. in database there is five schema like schema [a] [a].tbl_a -- Table [a].usp_a --Procedures [a].fn_a -- udf schema[b] [b].tbl_b --Table [b].usp_b --Procedures [b].fn_b --udf where [a] and [b] are the schemas. now i have to schedule full backup of only "[a]" schema objects. And there is only one file group(Primary) for database. using sql server agent job,is it possible or not?
-
i have to schedule backup of particular schema objects, using sql server agent jobs. in database there is five schema like schema [a] [a].tbl_a -- Table [a].usp_a --Procedures [a].fn_a -- udf schema[b] [b].tbl_b --Table [b].usp_b --Procedures [b].fn_b --udf where [a] and [b] are the schemas. now i have to schedule full backup of only "[a]" schema objects. And there is only one file group(Primary) for database. using sql server agent job,is it possible or not?
Here is suggestion which I have not tried with database backups but I have used from scheduling jobs with the windows scheduler. Create a batch program(text file with DOS commands, and with extension .bat). In the batch program connect to -iSQL and pass to it a .sql file that contains the backup instructions.--> That means you also have to create a .sql file. Now create a schedule in windows scheduler that executes the bat program Windows Scheduler calls mybackup.bat; mybackup.bat calls -isql which in turn calls mybackup.sql. Test the whole thing on test on test database.