Interested to Buy Any Domain ? << Click Here >> for more details...
What are SQL Jobs, please mention the use of it and how to
create them.
- 1 Answers
- 4778 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / subramaniam
sql job is scheduling the work into server and it will
automatically run and finish the job
for this we have to set the time.
what is the use of the job is
1) it check the database automatically
2)take a back up of database
for this job we have to start the Sqlserver agent and
give the date and time for this particular job
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to verify the port number of the sql server?
explain the storage models of olap? : Sql server database administration
Why I am getting this error when dropping a database in ms sql server?
What is acid mean in sql server?
What is store procedure? When do you use?
How many cores do I need for sql server 2016?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the difference between clustered and a non-clustered index?
How to generate create view script on an existing view?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
how many triggers you can have on a table? : Sql server database administration
How to define output parameters in stored procedures?
What are a database and a data warehouse?
