Hey thanks this is working.

Henry
----- Original Message -----
From: "Denis Gobo" <dgobo@w...>
To: "sql language" <sql_language@p...>
Sent: Friday, February 15, 2002 12:38 PM
Subject: [sql_language] RE: Running a procedure at a specific time


Little mistake replace Management/Jobs with  Management/sql server
agent/jobs

-----Original Message-----
From: Denis Gobo
Sent: Friday, February 15, 2002 12:37 PM
To: sql language
Subject: [sql_language] RE: Running a procedure at a specific time


Under Management/Jobs create a new Job
Click on the tab steps, click on new
In command type you query, change the database dropdown to the DB that
you are targeting
Click on the tab schedules, click on change   setup the schedule and
save the job and that's it

Denis


-----Original Message-----
From: HenryH [mailto:HenryH@p...]
Sent: Friday, February 15, 2002 12:33 PM
To: sql language
Subject: [sql_language] RE: Running a procedure at a specific time


That is what i am not sure how to do.

Thanks
----- Original Message -----
From: "Denis Gobo" <dgobo@w...>
To: "sql language" <sql_language@p...>
Sent: Friday, February 15, 2002 12:28 PM
Subject: [sql_language] RE: Running a procedure at a specific time


Create a job and schedule it

-----Original Message-----
From: henryh@p... [mailto:henryh@p...]
Sent: Friday, February 15, 2002 12:21 PM
To: sql language
Subject: [sql_language] Running a procedure at a specific time


I need to run a procedure once a month but i can't figure out how to
have it run automatically.
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
$subst('Email.Unsub').

---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
$subst('Email.Unsub').


$subst('Email.Unsub').

$subst('Email.Unsub').

$subst('Email.Unsub').