Visual Basic

USE msdb<br />
EXEC sp_add_job @job_name = 'BackupJob',<br />
@enabled = 1,<br />
@description = 'BackupJob',<br />
@owner_login_name = 'sa',<br />
@notify_level_eventlog = 2,<br />
@notify_level_email = 2,<br />
@notify_level_netsend =2,<br />
@notify_level_page = 2<br />
@notify_email_operator_name = 'myMailAddress'<br />
go<br />
-- Data backup<br />
USE msdb<br />
EXEC sp_add_jobstep @job_name = 'BackupJob',<br />
@step_name = 'msdb database backup',<br />
@subsystem = 'TSQL',<br />
@command = 'BACKUP DATABASE msdb TO DISK = ''c:\msdb.dat_bak''',<br />
@on_success_action = 3,<br />
@retry_attempts = 5,<br />
@retry_interval = 5<br />
go<br />
-- Log file backup<br />
USE msdb<br />
EXEC sp_add_jobstep @job_name = 'myTestBackupJob',<br />
@step_name = 'msdb Log backup',<br />
@subsystem = 'TSQL',<br />
@command = 'BACKUP LOG msdb TO DISK = ''c:\msdb.log_bak''',<br />
@on_success_action = 1,<br />
@retry_attempts = 5,<br />
@retry_interval = 5<br />
go<br />
-- Server specification<br />
USE msdb<br />
EXEC sp_add_jobserver @job_name = 'BackupJob', @server_name = N'(local)'<br />
<br />
-- Immediate job execution<br />
USE msdb<br />
EXEC sp_start_job @job_name = 'myTestBackupJob'

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

how to direct from 1form to another form & when i try to connected to Database the following error msg displays

"username not found"

the code
str ="username=hasitha;password=randika;databasemike;server=suntwo" 

aphei wrote:

a way to make datagridview readonly property become false

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.