Start the process by logging into the SQL Server Management Studio as an SA user and then expand “SQL Server Agent” as shown in the Fig below
Do right click on the jobs and click on “New Job” to create a new Job as shown in the Fig below
Now enter “Name “and Description for the Job as shown in fig below
After creating a Job, Do a Right click on the newly created a job for the database Indexing, Select Properties as shown in fig below.
Now Select Steps in the Job Properties as shown in fig below
In the New Job Step click on “Advanced “, here you can specify how do you want the job on both “success” and Failure Actions then click on Ok when you done as shown in fig below
Click on General, to choose eG Database, select the command file by using “open” and click on “OK” as shown in fig below.
Now you can see the Steps created for the Specific Job as shown in fig below.
Select schedules from the properties and click on “New” as shown in Fig,
New Job Schedule window will evoke and ask for the parameters like “Name” “schedule type” , Frequency at which the Job should run and you can mention at what time on a specific day the job should run and so on and click on “OK” as shown in the below.
Below fig showing “Schedule” is created
Tips:
To know how to create indexing script for eG, Click here.