I have created an agent job in SQL server 2008 but it is getting hanged when executing.
It is backup job which is running the below command
BACKUP DATABASE master TO DISK = 'E:\MSSQL10.INSTANCE_02\BACKUP\SystemDB\master.bak'
WITH NOFORMAT, NOINIT, NAME = N'System databases- Full Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
It shows executing and does not give any error. The job owner is sa. But whent excuting the same T-sql command in query window, it executes successfulle and creates the backups.
Do you have any idea on this?
//All our dreams can come true, if we have the courage to pursue them//