结构化查询语言SQL Agent Best Practices.pptVIP

SQL Agent Best Practices Gert E.R. Drapers SQL Server Development Customer Advisory Team GertD@SQLDev.Net Agenda SQL Agent Architecture Overview Best practices: Security Configuration Jobs Black Belt SQL Agent: Async Execution: Self Destructing Jobs Dealing with Job State Cluster support: Job Failover with Restart None sysadmin job execution: Job Dispatcher Monitoring: Detecting Runaway Jobs SQL Agent Architecture SQL Agent Security Best Practices Use separate security contexts Remove security info that is not used Use Windows Authentication between SQL Agent and SQL Server Registry and File