 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008sql job agent
hi, on 2000, i have created such job with stored procedure script(created on msdb database), inside the SP, we defined job name, job step , job schedule and job server, after created, i checked the step is : EXECUTE master.dbo.xp_sqlmaint '-CopyPlanName " xxx Log_Shipping" ' , but how this job know exactly what to do? thanks are these tables backup_movement_plans, backup_movement_plan_databases and backup_movement_plan_history get automatically created when maintenance plan created? how the data get loaded? thank you > hi, on 2000, i have created such job with stored procedure script(created on > msdb database), inside the SP, we defined job name, job step , job schedule > and job server, after created, i checked the step is : EXECUTE > master.dbo.xp_sqlmaint '-CopyPlanName " xxx Log_Shipping" ' , but how this > job know exactly what to do? thanks Hi You can either specify the options in the flags you set up, or pass a planname or id which defines the maintenance plan to use. Look up sqlmaint in books online for more information about the options. John > hi, on 2000, i have created such job with stored procedure script(created on > msdb database), inside the SP, we defined job name, job step , job schedule > and job server, after created, i checked the step is : EXECUTE > master.dbo.xp_sqlmaint '-CopyPlanName " xxx Log_Shipping" ' , but how this > job know exactly what to do? thanks but we didn't set up the maintenance plan, we just create a new job using stored procedure, so how does sql server know when i give a plan name called "copyplanname", it will actually copy the log from one server to another server? where do they retrieve the source directory info and destination info? thanks > Hi > [quoted text clipped - 9 lines] > > master.dbo.xp_sqlmaint '-CopyPlanName " xxx Log_Shipping" ' , but how this > > job know exactly what to do? thanks Hi If you don't set up a plan then passing the plan name of plan id would return an error. According to Books Online for sqlmaint the plan is only used to extract the database names that the other flags specify to be carried out, I suspect that xp_sqlmaint acts the same. If you specified a -D flag the database in question will have the maintenance tasks defined by the plan run against them. If there are no other flags then then no maintenance tasks will be run and all that would happen is a connection to the database is made and then dropped. John > but we didn't set up the maintenance plan, we just create a new job using > stored procedure, so how does sql server know when i give a plan name [quoted text clipped - 20 lines] >> > this >> > job know exactly what to do? thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.