What is a job?
Answers were Sorted based on User's Feedback
Don't post rubbish Answer
Jobs : A job is a specified series of operations performed
sequentially by SQL Server Agent.
A job can perform a wide range of activities, including
running Transact-SQL scripts, command prompt applications,
Microsoft ActiveX scripts, Integration Services packages,
Analysis Services commands and queries, or Replication
tasks. Jobs can run repetitive or schedulable tasks, and
they can automatically notify users of job status by
generating alerts, thereby greatly simplifying SQL Server
administration.
More Information Click This Link
http://msdn.microsoft.com/en-us/library/ms186273.aspx
| Is This Answer Correct ? | 3 Yes | 0 No |
A job is a scheduled work and the repeated things are won't
run manually which has to be run regularly when the agent
is started position It is important the job is run only
when the sqlserver agent is in the start position
| Is This Answer Correct ? | 2 Yes | 0 No |
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
how will u create "n" possible tables in sql...
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Equi join and non equi join is possible with sql server?
what is difference between having and where clause ?
Can we hide the definition of a stored procedure from a use?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the return type of executeupdate ()?
What are the steps to insert a table?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Which tcp/ip port does the sql server run on? How can it be changed?
What are the differences between char and varchar in ms sql server?
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)