how about one mentioned just below, is this what you mean:-

IF DATENAME ( dw , getdate() ) = 'Sunday' AND datepart(dd,getdate()) > 7

BEGIN

...

thanks all....anyway now jobs are not running.

first you create the package by BI console.

1) go to SQL Server Bussiness Intelligence Development Studion under Microsoft SQL Server 2005

2) go to File --> New --> Project

3) select "Integration...

its Enterprise edition SP2

I believe you can use sql agent job to execute one line cmd prompt script to execute the SSIS package.

for that you need to specify

To execute an SSIS package...

select * from sys.logins -- to get login informations

use [name of user database]

go

select * from select * from sys.sql_logins

i think following tables will be useful to you:-

select * from msdb.dbo.sysschedules_localserver_view

select * from msdb.dbo.sysschedules

if your intention is to drop the index then i think you dont have to specify field name,

you need to specify like this:

DROP INDEX [tablename].[indexname]

for example

DROP INDEX authors.au_id_ind

sorry i thought it is a SQL job..

you can use DTS by using "Transfer Logins Task" task.

create a step as last step (lets say : Email Status) of the job which notifys you by emailing. set the OnSucceess status of actual last step to this...

all the 4 tables are and destination are in same databases?

DBCC INDEXDEFRAG is command to defrag an index.

Hi SQL Oracle,

Thanks a lot !!!

Regards

Joseph

actually we are audience.. we do Development, operations, monitoring etc.

Actually A to Z things which are going on server or database ;)...just kidding..

Basically we need to monitor server health status,...