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.
| Author |
Topic |
|
Gazatteer
Starting Member
2 Posts |
 Posted - 2009-02-18 : 05:54:03
|
| HelloHow do I create a job to run vb.net procedure everynight. Is this possible?Thanks |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2009-02-18 : 06:39:34
|
| I have no idea about vb.net procedures but if you can start it from the command line you can schedule a job with the sql server agent and use either xp_cmdshell or use a job step of type "Operating system (cmd exec)"...- Lumbago |
 |
|
|
Gazatteer
Starting Member
2 Posts |
Posted - 2009-02-18 : 07:03:10
|
| thanks for suggestion.At the moment the procedure I like to run as part of a scheduled job is in an application (reasonably big application).I have just read an article on CLR stored procedures and I am beginning to think that's what I need to create. Am I on a right path?Should I write the vb.net class as CLR stored procedure? |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-02-18 : 07:27:33
|
| I would say that doing a CLR stored Procedure is the correct way as this used .net technologies, then from there create the job to execute that procedure |
|
|
|
|
|
|
scheduling a job to run a vb.net procedure