Using C# to create a scheduled job

[Dave]

I need to create an executible that will run on a nightly basis.

The executible is a simple command line statement like:

OSQL -Usa -PmyPasword -n -Q "BACKUP DATABASE msdb TO DISK =
'c:\msdb.dat_ba k'"
Is it possible to use C# to create an executible that will run this command
line statement on a scheduled basis?

If so, can anyone give me some general ideas on how to go about this?

[Pieter Jansen van Vuuren]

Hello Dave,

Why do you want to do this from C#?
Why don't rather just add a scheduled task?
Or in SQL create a scheduled job?

If you really want to execute this from C# use Process:

System.Diagnost ics.Process myProcess = new System.Diagnost ics.Process();
myProcess.Start Info.FileName = "OSQL.exe";
myProcess.Start Info.WorkingDir ectory = "C:\";
myProcess.Start Info.Arguments = "-Usa -PmyPasword -n -Q \"BACKUP DATABASE msdb TO DISK = > 'c:\msdb.dat_ba k'\"";
myProcess.Start ();

out of memory, so it might be buggy, but give it a try.

Cheers

Pieter

I need to create an executible that will run on a nightly basis.

The executible is a simple command line statement like:

OSQL -Usa -PmyPasword -n -Q "BACKUP DATABASE msdb TO DISK =
'c:\msdb.dat_ba k'"

Is it possible to use C# to create an executible that will run this
command line statement on a scheduled basis?

If so, can anyone give me some general ideas on how to go about this?

[Kevin Yu [MSFT]]

Hi Dave,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to start a job in schedule
tasks using C#. If there is any misunderstandin g, please feel free to let
me know.

To achieve this, you can either use Process.Start or WMI. The following
thread is a talking on this issue. HTH.

http://groups.google.com/groups?hl=e...sPfvzBHA.1712%
40tkmsftngp04&r num=2&prev=/groups%3Fq%3Dsc hedule%2Btask%2 BC%2523%2Badd%2 6hl%
3Den%26lr%3D%26 c2coff%3D1%26se lm%3DOw6sPfvzBH A.1712%2540tkms ftngp04%26rnum% 3
D2

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."