Use this procedure to configure automated SQL Server Agent jobs after the EDM has been deployed and configured to persist data from Context Store.
Note:
The Sample SQL Server Agent Scripts are applicable to both EDM co-resident with ACM and EDM installed alone on SQL Server(s).
Procedure
Log in to the SQL server which is used to take regular EDM transaction log backups and EDM full backups.
Note:
If using SQL Server Enterprise Edition, it is possible to use the secondary SQL server for this task.
If using SQL Server Standard Edition, it is not possible to use the secondary SQL server for this task. In such cases, you must use the primary SQL server.
Log into the local instance of SQL Server Management Studio.
In the Object Explorer pane, if SQL Server Agent is not enabled (red icon visible), right-click SQL Server Agent > Start.
Note:
If SQL Server Agent is required to start up automatically on reboot of the SQL Server, ensure that the Start Mode for the SQL Server Agent service is set to Automatic in SQL Server Configuration Manager > SQL Server Services.
Right-click Jobs > New Job.
On the General page, enter a name for the Job.
For example, EDMTransactionLogBackup
On the Steps page, do the following:
Click New and enter a name for the step. For example, Backup EDM.
Copy and paste a sample script into the command window.
For more information on how to customize the Sample SQL Server Agent script, see the ReadMe file included in the SampleSQLServerAgentScripts.zip file.
Click OK.
On the Schedules page, click New and enter a name for the schedule.
For example, Hourly EDM Transaction Log Backup.
In the Frequency section, in the Occurs field, select the appropriate option. For example, Daily.
In the Daily Frequency section, select either Occurs once at: or Occurs every:, enter appropriate value(s), and click OK.
For example, for an hourly transaction log backup, select Occurs every: and enter 1 hour.
Optional Enable Notifications to get notifications with the status of the job.
