Be the first one to answer the question Click here to answer

'3/4

Jobs: Using SQL Server Agent you can create and schedule jobs that automate routine administrative tasks. Database administrators create jobs to perform predictable administrative functions either according to a schedule or in response of events and conditions. Jobs can be simple operations containing only a single job step or can be extremely complex operations containing many job steps. SQL Server Agent is responsible for management and execution of all jobs. Agent must be running for jobs to be executed. SQL server 2k supports jobs containing operating system commands. Alerts: database administrators define alerts to provide event and performance condition notification and to execute jobs in response to SQL server events or performance conditions. E.g. when the log is 90% full an alert can be configured to fire a job that executes a job to back up and truncate the transaction log.

It is part of the NAIC security insurer provisional exemption rules: A. Optionality Test: for corporate and municipal issues, principal and interest must be paid in US dollars, contract terms state that principal is repayable in full and the principal repayment schedule is fixed. Further the principal is set at closing, fixed in US dollars and coupon payments cannot be less than zero in any period. B. Optionality Test: for Asset-Backed/Residential Mortgage-Backed securities, the principal and interest must be paid in US dollars, and the coupon payment cannot be less than zero in any payment period. In addition, with the exception for credit enhancements, the timing and amount of cash flows to pay the obligation must depend on the timing and amount of cash flow from the assets underlying the bond. If the bond is prepaid immediately, the insurer must receive at least 98% of the purchase price.

Window a windows NT user account with administrator privileges,SQL Server cannot schedule task  and alerts, or perform replication.

I would first plan it out with my staff, set all needed preparations, then proceed only when everything has been considered and taken care of.

We often anticipate possible delays by having contingency plans, or by doing combining other tasks which can be done in a shorter span of time.

It's all time management. I plan my work 2 days ahead, and it includes contingencies incase there are delays or problems that may come my way.