MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
You can use SSMS to create jobs or you can execute which system stored procedure. Choose one
A
sp ____ add ____ job
B
sp ____ execute ____ job
C
sp ____ run ____ job
D
None of the above
Explanation: 

Detailed explanation-1: -Using SQL Server Management Studio Expand SQL Server Agent, create a new job or right-click an existing job, and then click Properties. In the Job Properties dialog, click the Steps page, and then click New. In the New Job Step dialog, type a job Step name. In the Type list, click Transact-SQL Script (TSQL).

Detailed explanation-2: -Using SQL Server Management Studio Expand the database that you want, expand Programmability, and then expand Stored Procedures. Right-click the user-defined stored procedure that you want and select Execute Stored Procedure.

Detailed explanation-3: -Within SQL Server Studio, stored procedures, or procedures for short, reside within any database, under the programmability subdirectory.

There is 1 question to complete.
Previous
Next