Hello I am attempting to run a backup job on a server from a batch file using OSQL. I am using the following syntax
osql -S "SERVERNAME" -E -q"EXEC msdb.dbo.sp_start_job 'JOBNAME'"
I am trying to figure out if their is a way to display when the job completes in the command prompt. My goal is to create a script that will allow a user to run a SQL job and have some sort of notification as to when the jobs completes.
O yeah this is a SQL 2000 instance.