| Author: www.DotNetVJ.com 08 Oct 2008 | Member Level: Diamond | Rating: Points: -20 |
Hi
In the daily routine of a database administrator or a database developer, SQL Server has some functionality that can make life simpler and more dependable in the long run: SQL Server jobs.
A SQL Server job is a collection of steps executed by the database engine by SQL Server Agent.
The job can perform many different functions within it that can save time and effort on the part of employees.
For example, a job can be created to import a daily update file internally or externally via an FTP server.
Check out the below link for more information
http://www.databasedesign-resource.com/sql-server-jobs.html
Thanks -- Vj
http://dotnetvj.blogspot.com
http://oravj.blogspot.com
Thanks -- Vijaya Kadiyala
http://www.DotNetVJ.com
Microsoft MVP
Me & My Little Techie
|
| Author: saisrikanthreddy 08 Oct 2008 | Member Level: Gold | Rating:  Points: 2 |
You can write a job in sql server to run a stored procedure
at a specified time
|
| Author: Vivek 08 Oct 2008 | Member Level: Gold | Rating: Points: 2 |
You need to schedule a job and in that job you can call your store procedure, Job can be scheduled to start daily at specified time.
|
| Author: fayaz 08 Oct 2008 | Member Level: Gold | Rating: Points: 2 |
create a .vbs(script) file in which stored procedure is called.
now got to control panel -> scheduled tasks ->Add scheduled tasks.... here you can set the time when the stored procedure must be executed
Regards,
Faiz
|
| Author: Sathish 09 Oct 2008 | Member Level: Silver | Rating: Points: 3 |
Create a porting routine that contains the execution query:
The steps will be as follows:
1. Open Enterprise Manager
2. Connect to the server
3. Navigate to Data Transformation services
4. Right-Click on Local Package & select new package
5. In the new wizard, select a server item & define your connection properties
6. From the task pane, select item 'Execute Task'.
7. Double-click on the 'Execute Task', define the previous connection name & the exec script of the procedure
8. Save the Package.
9. In the package list, right click on the newly created package and select schedule and schedule the package as needed.
Note: For scheduleing the package, you must have sysadmin access.
For more information visit: http://www.devarticles.com/c/a/ASP/Creating-DTS-Packages-With-SQL-Server-2000/
|