writting a job to drop a db - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

writting a job to drop a db

Author

Topic

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-11-18 : 13:02:51

Hi Guys,
I need help to write a job which export the databse scripts including all procs and all information to excel or in a file,as well i want to put a option to check a particular dat and after that want to drop the database. Is it possible

SQL IN Minds

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-18 : 17:54:53

Have you looked at DTS package?

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-11-24 : 07:49:01

ho sodeep I have checked dts package transformaing data using DTS is not an issue I want set a parameter after certain time and specially looking for hardcode it

SQL IN Minds

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-24 : 08:50:46

quote:
Originally posted by YogeshDesai

ho sodeep I have checked dts package transformaing data using DTS is not an issue I want set a parameter after certain time and specially looking for hardcode it

SQL IN Minds

set a parameter for what? perhaps you could schedule a job for running this package at convienient time if thats what you need.

YogeshDesai
Posting Yak Master

136 Posts

Posted - 2008-11-24 : 10:14:15

hi visakh i want to set parameter or somthing like that which will check the date and after the certain date it will drop the database, and i want to schedule a job which export all the database script with all information, in excel or txt file

SQL IN Minds

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-24 : 10:45:16

quote:
Originally posted by YogeshDesai

hi visakh i want to set parameter or somthing like that which will check the date and after the certain date it will drop the database, and i want to schedule a job which export all the database script with all information, in excel or txt file

SQL IN Minds

why do you want to do that?
anyawys, i think you can do it via sql jobs.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources