I accidently deleted a SQL Server Agent Job that contained a number of steps, that I need to get back. Does anyone know how I can restore a deleted job? I have a number of FULL SQL backups of the system databases, and production databases we use. I'm assuming it was stored in the master DB? Any help would be greatly appriciated. Thanks -Phil-
Update:
No rush, I did some digging and found the steps in a backup of the msdb sysjobsteps table. I'll paste them back into the job. Was just wondering if there is an easier way if this happens again. -Phil-