PrepAway - Latest Free Exam Questions & Answers

Tag: vc oracle store procedure

which implementsthe stored procedure; however it should delete the job when it is finished.What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
The SQL Server 2008 instance has a stored procedure which runs a database maintenance process.
You were instructed to develop a SQL Server Agent job which implements
the stored procedure; however it should delete the job when it is finished.
What should you do?