KPatSQLServer
Hi,
I am using SQL Server 2005.
Under SQL Server Agent there is a job...Job1. Which has been disabled by the previous DBA. Needless to say that the DBA no longer works for the company.
I am trying to get more infor about this Job. So I right clicked the job and "Script Job As" --> Create to File and view it..All it shows is:
Exec msdb.dbo.sp_add_job
Exec dbo.sp_add_jobstep
Exec msdb.dbo.sp_add_jobschedule
This is not what I want. I want to know what the job does.
Then I right clicked the Job and did properties and then Steps and finally Edit..That gives me:
NameOfDBServer\DTS Packages\Copy Database Wizard Packages\Name of Job..
But what I want to find out is what does the job actually do
Please help me.