资源描述:
《sqlserver定时调度》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、(1)OpenEnterpriseManager,enteryourservernameinthe"management"tostarttheSQLServerAgent.Andthenviewtheserverproperties,selectthe"AutomaticallystartSQLServerAgent". (2)Next,entera"job"undertheSQLServerAgent,choose"NewJob"ontherightpoint,right. (
2、3)inthe"General",justenterajobclassificationtochoosethelastone"databasemaintenance". (4)Inthe"steps"point"NewSteps",justenterthenameofastep,thedatabaseselectedintoyourdatabase,youdeleterecords,enterinthecommandstatement,canalsobe"Open"toloadtheT-
3、SQLscript.Onceyou'vegotremembertoanalyze,thereisnoproblemtocontinue."Advanced"failedoperation"to"gotothenextstep. (5)inthe"Scheduling",pointtoNewscheduling",justenteraschedulingpointof"Change",thefrequencyofselecteddaily"happenedon"set17:00:00,and
4、thenOK,andthenclick"OK",thenclick"OK",theconfigurationiscomplete. OriginalSource:hi.baidu.com/yuan0762/blog/item/25b1ad2bb37989f9e7cd404f.html SQLServer:regularjobsettingSource:SANIfyouneedtimetotimeorfromtimetotimetoexecuteastoredprocedureorSQ
5、Lstatementinlessthan3200charactersinSQLServer,canusetheManagement->SQLServerAgent->operationstoachieve.1Management->SQLServerAgent->job(clicktherightmousebutton)->NewJob 2,theNewJobProperties(General)->name[thenameofthecustomofthisassignment]->enable
6、dboxisatick->ClassificationServicecanchoosethedefaultavailable[Uncategorized(Local)]->ThedefaultloginSQLServerusers[alsooptionalotherlogin]->description[fillinthedetaileddescriptionofcontent];Tocreateajobclassification:SQLServerAgent->Job->rightclick
7、selectAllTasks->Add,modify,delete 3,theNewJobProperties(step)->New->Stepcustomizethenameofthefirststep]->typetheTransact-SQL(TSQL)scripts]->database[thedatabase]->command[IfsimpleSQLtowritedirectlyintothecanalsobeusedtoopenthebuttonstoenterawritten*.
8、thesql.Fileifyouwanttoexecuteastoredprocedure,fillintheexecp_procedure_namev_parameter1,the[v_parameter2v_parameterN]->(iftherearemultiplesteps,youcanonceagaincalltheNewbuttonbelow;havebeenanumberofstepstoinsert,edit,delete); 4constructionjobattribut