• Hey..

    can u able to explain the code in little bit brief once...

    because It is not working in my system.. while try to connect the remote server and as well as local system also...

    check below

    ECHO Executing job

    ECHO.

    pause

    osql -S "ws-1" -E -Q"exec msdb.dbo.sp_start_job 'BACKUPTEST' "

    ECHO Job execution completed

    pause

    CLS

    EXIT

    Note : ws-1 is my server name when i open sql2005 it displays (ws-1\sqlexpress).. which one is correct...