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.



Re: SQL Server Agent Question

Phil Brammer


Moving to SQL Server Tools General. This is not an SSIS question.






Re: SQL Server Agent Question

Arnie Rowland

Using SSMS, in the Object Explorer, [double-click] on the Job to open the property sheet.

[Double-Click] on each step in order to see the command for that step,

When you 'sort it out', for future reference, enter an explanation in the Description box.







Re: SQL Server Agent Question

Vidhya Sagar

Hi,

KPatSQLServer wrote:

NameOfDBServer\DTS Packages\Copy Database Wizard Packages\Name of Job..

But what I want to find out is what does the job actually do


The job what you have mentioned above is a scheduled job of "Copy Database Wizard", your old DBA has tried to copy database from one server to another server and he has used copy database wizard, so if the job runs it will copy the database from the source server to the destination server as mentioned inside package..

Example. Job name looks like "CDW_SAGARSYS_SQL2K_SAGARSYS_x"

Where CDW - copy database wizard
SAGARSYS_SQL2k - Destination server (This is my sql2k server as instance)
SAGARSYS - Source server (This is my sql2k5 default instance)