What are SQL Jobs, please mention the use of it and how to
create them.
Answer / 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 |
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
How make remote connection in database?
What are the differences between having and where clause.
What it means to be triggered?
What is cursors? And what are the different types of cursor?
what is DTS what are tasks available
How do use Having,Group by,Group function in SQL?
What is an sql server agent?
Do you know what is a trace frag? Where do we use it?
What is indexed view?
Can binary strings be converted into numeric or float data types?
What are types of storage modes? : sql server analysis services, ssas
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)